Monday, March 19, 2012

Move SQL Server 2000 database C: to D: drive

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

No comments:

Post a Comment