How to move DB from one server to another

[darwin101]

Hi all

We will need to move a sql server 2k database from one server to another. The new server has more cpu's and a different disk subsystem (3 sets of disk). One for the OS, one for Transaction Logs, the last for the data files.
Is this something we can do? It's a non profit and we can't afford to bring in an expert. Could someone point me to directions or something.

Thanks

 

[JayKusch]

Go into Enterprise Manager(EM), right click the DB you want to move and choose detach database. This will then let you move/copy your database file, the MDF file, to the data disk. Then move/copy the transaction log file, the LDF, to the transaction log disk. The get into EM on the new server, right click on the database tab and choose attach database. Point to each of your newly moved MDF and LDF file and the DB should attach for you.

Thanks

J. Kusch

 

[darwin101]

Hi J.

Thanks, I thought there would be alot more to this. Guess I need to go buy a dummies book.