Troubleshooting: Backup error - Database msdb cannot be opened

From AutoCount Resource Center
Revision as of 07:02, 21 February 2020 by LaySwan (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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.


1. Uninstall current Microsoft SQL Server and reinstall Microsoft SQL Server.


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.


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:

Version 706 3.png

By:CK 170825, KM 170828, P170911

Go to menu

IconAcc20.PNG AutoCount Accounting 2.0 & 2.1

IconAcc188.PNG AutoCount Accounting 1.8 / 1.9
Wiki-Payroll.png AutoCount Payroll
Wiki-POS.PNG AutoCount POS

Wiki-AOTG.PNG AutoCount On The Go
Wiki-Accounting-Plugin.png AutoCount Accounting Plug-In Documentations