Tuesday, March 6, 2012

a related question - how to convert from sqlexpress to sql server 2005

how does one convert from sqlexpress (mdf files) to sql server 2005 and vise-versa, ie from SQL Server 2005 to SQLExpress mdf files?Attach & detach is the easiest way to go :-)|||

What if you don't have the ldf for the SQLExpress database?

|||Look in Books Online for the usage of [sp_attach_single_file_db]
Posted by Crystal at 11:29 PM
Labels: , , , , , , , , , , ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)