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 July 29, 2008 at 9:56 am and is filed under SQL Server - Maintenance. 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.

One Response to “How to restore MSDB Database”

Adam Gorge Says:
February 21, 2012 at 10:14 am | Reply
You have described the solution only for those users who have updated backup. But in case users don't have backup then what should we do? In this case, SQL Database Recovery Software can recover corrupt SQL Server Database. You can also choose for Third party software which can easily installed & recover data in few easy steps.

Lets SQL