Troubleshooting: Backup error - Database msdb cannot be opened

From AutoCount Resource Center
Jump to navigation Jump to search

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


Msdb1.png


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.

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.


Msdb2.png


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


Msdb3.png


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:


Version 706 3.png


By:CK 170825, KM 170828, P170911

Go to menu

IconAcc20.PNG AutoCount Accounting 2.0


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