Database 'msdb' cannot be opened. It has been marked SUSPECT by recovery

Article ID

ias-12355

Article Name

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

Thank you for your feedback.

Was this useful?

Yes No

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.

Escalate to Support?

First Name *

Last Name *

Company Name *

Email Address *

Phone Number *

IRIS Feedback *

For information on how we manage your data please view our privacy policy