QUESTION POSED ON: 21 December 2005 I can restore our database to another server and give users access without any problems, but I also have a large quantity of jobs and DTS packages. Can I restore the MSDB to this other server too? Or do I have to do something with the master database or anything else for that matter on the second server before or after restoring the MSDB?
>
The cleanest approach would be to move the jobs and the DTS packages to the new server. This can be done using DTS tasks.
Search and Browse the Expert Answer Center Search and browse more than 25,000 question and
answer pairs from more than 250 TechTarget industry experts.
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.
