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
 Transact-SQL (2005)
 Moving a db

Author  Topic 

itsarnie
Starting Member

18 Posts

Posted - 2010-05-24 : 03:32:27
Hi I want to move the .mdf and .ldf files to a new location. Please tell me how to do it.

Regards,
Arnie.

Thanks and regards
Arnie,

lazerath
Constraint Violating Yak Guru

343 Posts

Posted - 2010-05-24 : 14:05:05
Depends on if it's a user database or a system database (and which system database). Here's some information:

http://support.microsoft.com/kb/224071
Go to Top of Page
   

- Advertisement -