Thank you for the advice guys. Actually, I want to copy not only the databases but *everything*. Users, scheduled jobs, DTS packages, etc...

I've tried the Copy Database Wizard on 8 different occasions. Each time I've run it, the copy fails with "unspecified errors"-

Step Error Source: Microsoft Data Transformation Services (DTS) Package
Step Error Description:Unspecified error

Step Error code: 80004005
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:1100


The reason that I want to copy everyting onto another server is that our production server is being replaced by a new machine. I am prepared to Detach and re-Attach each database and recreate all of the DTS packages, scheduled jobs and users manually. I was hoping there was a cleaner and less labor-intensive way of doing it.

- Keith Payne


>>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.