Troubleshooting: Backup error - Database msdb cannot be opened

Question: Why can't I backup account book? There is an error message prompted: 'Database msdb cannot be opened. It has been marked SUSPECT by recovery'.

Version: 1.8 / 1.9 / 2.0

When expand database at SQL Management studio, prompted error “ Database ‘msdb’ cannnot be opened. It has been marked SUSTPECT by recovery.”

Possible Reason:

System Database MSDB might have been corrupted or the ldf file does not match with the mdf file.

Solution (1):

Uninstall current Microsoft SQL Server and reinstall Microsoft SQL Server.

Solution (2):

Copy the MSDB file from another pc to replace it.

2.1 Press the Windows button and type Services.msc or go to Control Panel > Administrative Tools > Services. Right click on selected SQL Instance and click on stop.

2.2 Copy the MSDBData and MSDBLog File and replace into destination folder and start the SQL Services.

2.3 Now, you should be able to back up from AutoCount.

By:CK 170825, KM 170828, P170911

Solution (3):

3.1 Press the Windows button and type Services.msc or go to Control Panel > Administrative Tools > Services. Right click on selected SQL Instance and click on stop.

3.2 Open File Explorer and go to C:\Program Files\Microsoft SQL Server\MSSQL11.A2006\MSSQL\Binn\Templates.

3.3 Right click and copy msdbdata and msdblog file from this folder.

3.4 Then paste and replace the msdbdata and msdblog file at C:\Program Files\Microsoft SQL Server\MSSQL11.A2006\MSSQL\DATA.

3.5 Right click and start SQL Server Services.

3.6 Now you should be able to expand the database in SQL Management Studio and backup from AutoCount.

Note:

Path for OS 64 bit:

C:\Program Files\Microsoft SQL Server\MSSQL11_50.A2006\MSSQL\DATA

Path for OS 32 bit:

C:\Program Files\Microsoft SQL Server\MSSQL11_50.A2006\MSSQL\DATA

You can see there is a version number there. Different version number represent different version of SQL Server. List of version number patterns and database versions can be found as below: