Migrate a sql 2005 express db to sql 2005

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Express Edition and Compact Edition (2005)

Migrate a sql 2005 express db to sql 2005

Author

Topic

BitShift
Yak Posting Veteran

98 Posts

Posted - 2007-06-04 : 17:44:12

Can I just take the mdf file and put it in my data folder, then attach it in sql 2005 ? What about the ldf file ?

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-06-04 : 22:55:24

Copy both mdf and ldf files to sql2k5 server and attch them.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources