What is the best way to move a SQL Server 2000 database from the C: to D:
drive?
Thanks,Using Enterprise Manager, "Detach Database"
Go head and move the MDF file and LDF file (if you want to move log file
also)
Then using Enterprise Manager, "Attached Database"
Browse the MDF file from new location...
MC
"Joe K." <Joe K.@.discussions.microsoft.com> wrote in message
news:7B1448F9-16B6-4EAC-9DA1-30F98C127BE7@.microsoft.com...
> What is the best way to move a SQL Server 2000 database from the C: to D:
> drive?
> Thanks,|||http://www.nigelrivett.net/SQLAdmin/MoveDatabases.html
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment