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

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.

OR

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.

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: