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

Product

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