I have two instances of Sql server 2000(Test and
Production) running on my machine.I am trying to refresh
the test environment with production production
environment.I backed up the prodcution user database and
restored in test and it worked fine.Now I need to move all
my production DTS packages to Test.So I backed up the MSDB
database and tried to restore in Test.But it gives an
error saying that the MSDB is in use.I do not see anybody
1.Is there any better way other than backing up MSDB and
restoring it to move DTS packages?
2.What is the reason for getting the error message MSDB is
3.When I move DTS packages do I have to do something to
the MASTER database?
4.What is the best way to find out whether Test and
Production are in sync?
Thanks in advance for the help