Restore MSDB

Posted: December 1, 2010 in DBA, SQL 2005

A few jobs were deleted when they shouldn’t have been. This was on a Dev server so the easiest way to fix it was restore to MSDB.

How to Restore

Create a new database called msdbTemp
Restore the last good backup of msdb over msdbTemp
Now backup msdbTemp
Stop the SQL Agent – and kill any other processes in MSDB
Restore MSDB from database MSDBTemp – use overwrite for the data and log files.
Re-start the SQL Agent
Take a backup of MSDB

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s