Replacing server

[nirs]

hi
i need to move my sql server 2000 databases to a new server
the new server is installd and configured
now i just need to move the data
what is the best way in order to keep all the ruls atc.
thank you

 

[SQLSister]

IF you can take down the database on the server it is on the fastest method is to detach the database, copy the physical files and the attache teh database onthe new server. YOu might want to make sure all the users are properly set up on the new server first or you might run intothe orphaned user problem.

You can also use backup and restore. Backup existing database and restore on new machine.

 

[ecobb]

If I'm not mistaken, you can restore/overwrite the master database on the new sever with the master database from the old server and it will set up all of your users for you. BUT...only do this if the new server has NOTHING (different) on it, otherwise you will overwrite all of the stuff on the new server.

I could be wrong about this, but I know in the past when I've had to restore an entire server, when I restored the master database all users and permissions were restored with it.

Hope this helps!