backing up SQL database for vcenter

[dst2000]

Hi,

I have recently installed a vcenter version 4.  It does come with SQL server 2005 for free.  I would like to backup my data base.  Can I use 2008 Mangement Studio Express to backup the data base?  Here is the link I am talking about:

http://www.microsoft.com/download/en/details.aspx?id=22985

Thanks

[a_p_]

Since the free SQL Express edition does not include the SQL-Agent, you can only do manual backups in the GUI. However there are several web sites which describe how to automate backups for this edition. see e.g. http://www.sqldbatips.com/showarticle.asp?ID=27

André

[dst2000]

Manual backup is OK for me, I do not make too many changes to the database.  But it is safe to install the 2008 Management application on the server which has 2005 SQL installed.

[a_p_ · Accepted solution]

Usually I install the Management Studio in the same edition as the database. However, I'm almost 100% sure that a newer Management Studio supports older databases.

André

[MauroBonder]

HI, Maybe Data Migration Tool can help with this migration.

http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=102163...

Please, don't forget the awarding points for "helpful" and/or "correct" answers. 

Mauro Bonder - Moderator

[dst2000]

Thanks