How do I fix suspect MSDB database?

Question

3 Quick Ways to Recover a Suspect MSDB database in SQL Server Recover MSDB database using Backup. . Get hold of an MSDB backup from another SQL Server Instance. . Make use of MSDB Database Template in SQL Server.

How do I clean up MSDB database?

You could use the database maintenance plan – Cleanup History task and configure it to clean up backup tables automatically. Select the Cleanup History task in the maintenance plan and click Next. On the next page, select the value for the “Remove historical data older than” parameter.

How do I rebuild Msdb?

Using the Windows Notepad, open the instmsdb. out file and check the output for any errors. Re-apply any hotfix installed on the instance. Recreate the user content stored in the msdb database, such as jobs, alert, etc.

What happens when Msdb DB is down?

If Msdb is down, then your sql server agent wont start, hence the jobs will not even run in the first place.

What happens if Msdb is corrupted?

You have to fix a corrupt SQL Server msdb database and to make things worse, there is no recent database backup. If you run setup with the option REBUILDDATABASE you will also rebuild the master database and lose all the logins unless you backup and restore the master database.

Expert · Answer