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

Sin_Chase · 12 Nov 2009 at 12:56

Probably best to just put it all on SQL 2008 and avoid confusion!

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.

faugusztin · 12 Nov 2009 at 13:25

Yes you can, you just need to have the SQL2008 running on different port and with different instance name.

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?

faugusztin · 12 Nov 2009 at 14:23

It will use less memory and resources - but if you need different versions, then it is possible (google for it).

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?

unclepablo · 15 Nov 2009 at 20:50

As per the other posters, yes you can run both SQL instances but there isn't a lot of point "assuming" the application that currently runs on MSDE is supported running on SQL 2008 - I'm assuming your MSDE is SQL 2000/2005

Might just need to re-point the MSDN application to the new SQL 2008 install. Check how with vender I guess (or look for a connection in Admin Tools > Data Sources)

HTH
UP

Sin_Chase · 15 Nov 2009 at 20:51

wijcc said:
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?

Yes you can use full fat SQL assuming your application lets you point at an instance, which would be very strange if it did not!

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

ethos · 30 Nov 2009 at 15:18

The default instance is stored at "C:\Program Files\Microsoft SQL Server\MSSQL\Data" by default. You should find a bunch of .mdfs that related to the DBs you run.

If you are running named instances it's normally "C:\Program Files\Microsoft SQL Server\named instance".

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

Sin_Chase · 1 Dec 2009 at 17:37

Volume Shadow Copy, an SQL agent for your backup software or schedule SQL backups to flat files for later backup.

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

Sin_Chase · 1 Dec 2009 at 17:48

MS in their infinite wisdom messed up backup scheduling with SQL Express 2005 but someone has a project which may be of use to you.

See:

http://www.codeproject.com/KB/database/SQLAgent.aspx

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