How to Restore MSDB Database

How to restore MSDB database

If your msdb goes suspect then you have two choices, if you have backup of database then restore it else you have to recreate it

If you want to recreate it here are the steps to do it

1. Start the server with trace flag 3608.Detach the damaged msdb.
2. Navigating to the directory ‘C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn’ and start sqlservr.exe -c -T3608
3. Move or rename the damaged msdb files
4. Go to the folder ‘C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Install’ and run the instmsdb file.
5. Restart SQL Server without the 3608 trace flag

This entry was posted on August 31, 2009 at 8:20 am and is filed under Uncategorized. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Lets SQL