SQL Server Performance Forum – Threads Archive
moving SQL 2k to another location
Hi, I am running SQL 2000(SP3) on W2K Server. I have a database installed on a C: drive, and Ineed to move it to an F: drive on the same machine.( Need to move all system databases also) whats the best way to do it?? Thank you!
sadbhaw
detach the database, move the files into your other drive and attach the database.
You can do it with EM or look in BOL for sp_attach_db, sp_detach_db. Bambola.
Yamahacfd, kindly keep your queries in one thread and avoid posting multiple (duplicate) threads.
Most of your threads resembles similar query and similar solution by Peers.
(Locked this thread) _________
Satya SKJ
Moderator
SQL-Server-Performance.Com
]]>