Archive for December, 2010

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