Q

What's the best approach for restoring MSDB on another server?

Expert Greg Robidoux explains how to restore MSDB on another server while also allowing users access.

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.

For detailed info on how to migrate DTS packages, please refer to this article:
http://www.sqldts.com/default.aspx?204

This was first published in December 2005

Dig deeper on SQL Server Backup and Recovery

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close