Can I restore SQL Server Express 2005 to SQL Server 2005?

Can I restore SQL Server Express 2005 to SQL Server 2005?

Post by Ynl0ZW1hb » Sat, 26 May 2007 07:13:01


Hi, I have the following questions:

Can I make a full DB backup with SQL Server Express 2005 ?

that backup, can I restore it to another SQL Server Express 2005 ?

that same backup, can I restore it to SQL Server 2005 (not Express) ?

Can I generate a DB backup in some open format (like xml) with some T-SQL
command(s) ??
--
Thanks for your help
 
 
 

Can I restore SQL Server Express 2005 to SQL Server 2005?

Post by Strid » Sat, 26 May 2007 09:08:51


Absolutely.

Same syntax as the big brothers.



Absolutely. Would be a pretty useless backup if you couldn't do that.



Ayup. You can go the other way to if the backup is small enough.

Note however you may need to remap users to logins on the new machine.



No.

That's an interesting idea though.

You can BCP out individual tables using a query as XML. Script that and
you'd have your data, but not the schema.





--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.yqcomputer.com/