Database ‘msdb’ cannot be opened. It has been marked SUSPECT by recovery
Article ID
ias-12355
Article Name
Database ‘msdb’ cannot be opened. It has been marked SUSPECT by recovery
Created Date
14th November 2016
Problem
Database 'msdb' cannot be opened. It has been marked SUSPECT by recovery. See the SQL Server errorlog for more information. (Microsoft SQL Server, Error: 926).
Resolution
Open the Run dialog, (Windows + R keys).
Type services.msc and press Enter.
Locate SQL Server (IRISPRACTICE) and select Stop.
Go to the following location C:Program FilesMicrosoft SQL ServerMSSQL10.MSSQLSERVERMSSQLDATA
and move MSDBData.mdf & MSDBlog.ldf to any other place
Replace the MSDBData and MSDBlog files in this location with a copy from C:Program FilesMicrosoft SQL ServerMSSQL12.SQL2014EXPRESSMSSQLTemplate Data
Open the Run dialog, (Windows + R keys).
Type services.msc and press Enter.
Locate SQL Server (IRISPRACTICE) and select Start
We are sorry you did not find this KB article helpful. Please use the box below to let us know how we can improve it.