Workaround for the msdb database suspect

1. Causes

Computer room power outage, server illegal shutdown, resulting in msdb database was "suspect"

The role of 2.MSDB databases

The MSDB database is used by the SQL Server Agent to dispatch alerts and jobs, and to record operators. For example, we backed up a database and inserted a record in the table Backupfile to record the associated backup information.

3. Implementing the Logic

Since the msdb database does not store particularly important information, it is possible to copy an identical msdbdata.mdf and msdblog.ldf from another machine.

4. Steps to Resolve

A server is a "suspect" server, and B server has the same version of the database software as the a server. My version is SQL SERVER 2000.

Step 1, stop the SQL Server service on the B server, and copy the "Msdbdata.mdf" and "Msdblog.ldf" files.

Step 2, stop the SQL Server service on Server A, and overwrite the two files on the a server with the "Msdbdata.mdf" and "Msdblog.ldf" files copied from the B server. 3. Restart the SQL Server service on the a server.

Step 3, if the msdb database is still suspect, you can execute the following SQL.

Workaround for the msdb database suspect