Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Moving databases from one server to another?

Author  Topic 

bgreenaway
Starting Member

4 Posts

Posted - 2007-12-12 : 13:24:43
I am currently running a small SQL Server 2000 database called TOOLDATA on a very old server (SERVER1) which I wish to scrap and want to transfer it to another server (SERVER2) which is already running SQL Server 2000. The target server already has a copy of the TOOLDATA database but it is not used and is very out of date.

Can someone provide or point me to an idiot-proof procedure on transferring the entire database from SERVER1 to SERVER2, retaining the same same database name (TOOLDATA) but overwriting the out of date version on the target server?

Any help greatly appreciated.
   

- Advertisement -