SQL express and SQL

wijcc · 12 Nov 2009 at 11:28

Hey guys i have a quick question regarding SQL express and SQL. I currently have SQL express 2005 installed which is being used by Websense Express. But I now need to install another program which comes with SQL 2008. Can I have both SQL and SQL express running at the same time? Or is it better for me to uninstall SQL express and websense, then install the new program and SQL 2008. After which reinstalling websense express?
Thanks in advance guys

wijcc · 12 Nov 2009 at 13:22

thought as much.. i will have to uninstall sql express and re-install the websense express after installing SQL 2008
Thanks.

wijcc · 12 Nov 2009 at 13:28

but would it be easier and more efficient just to have only SQL 2008 running and have both programs use SQL 2008?

wijcc · 12 Nov 2009 at 14:45

I have another application that uses MSDE, can that program use SQL 2008 instead of MDSE.. or will i have to leave MSDE on the server?

wijcc · 16 Nov 2009 at 16:27

thanks for info guys

wijcc · 30 Nov 2009 at 14:24

I need a bit of help now with regards to backing up the SQL databases, where would they be stored? I have SQL 2008 install at C:\program files... etc.
I currently have a batch file which I run to backup to A NAS drive.. which folders would I need to add to the is batch file inorder to save the SQL databases/table data to the NAS?
THanks in advance guys

wijcc · 30 Nov 2009 at 15:39

thanks mate

wijcc · 1 Dec 2009 at 13:25

i have a problem backingup/copying these files... the error message i get is:
Error copying "C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\master.mdf" to "\\192.168.0.61\public\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\master.mdf": The process cannot access the file because it is being used by another process.

How can i work around this? Ideally I want a automated backing up system.
Thanks guys

wijcc · 1 Dec 2009 at 17:42

thanks... how would i incorporate this into my batch file and cobian 9 backup which I also use?
Thanks again

wijcc · 1 Dec 2009 at 23:49

Just to let guys know that the latest version of Cobian backup uses VSS, I will be running it tonight and will let you know if it works