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
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.