moving SQL 2k to another location | SQL Server Performance Forums

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 I
need 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!
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