>I have 2 SQL Server 2000 servers. Is there a tool or process by which I can copy of everything from one server to another?
>
>I am guessing that it can be accomplished with replication. I want to replicate the first server onto the second and then somehow disconnect them while preserving everything on the second server. Unfortunately I don't have any experience replicating servers and I am not certain how to proceed.
>
>Any insight is greatly appreciated.
>
>TIA,
>

Keith,
If the configuration settings are the same between the two servers, you can choose to Backup the database. In EM, right-click on the database and select Backup database from the menu. Choose Backup to Disk and click on Add to add a file name. This will dump eveything to disk.

Move the file to the new server. Right-click on the Databases node and select Restore database from the menu. Enter the name of the database (you don't have to select one that's there). Select From Devive and then click on Select Device to browse the hard drive for your file.

HTH.