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
 SQL Server Administration (2000)
 Restoring System DBs to another machine?

Author  Topic 

Mmats
Starting Member

47 Posts

Posted - 2005-09-19 : 16:58:56
Im wanting to make a backup clone of one of my servers and one of the problems I ran into with SQL was replicating the DTS packages. I wrote my own replication program that restores all user databases to this backup machine, so should I add the system DBs to the script or would that not work? Running win2k sp4 and sql2000 sp4

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-09-19 : 17:00:32
It isn't recommended, but it'll work if the paths to the MDFs and LDFs is the same on both servers.

Tara
Go to Top of Page

Mmats
Starting Member

47 Posts

Posted - 2005-09-19 : 17:05:51
Good news, thanks
Go to Top of Page
   

- Advertisement -