Troubleshooting: Backup error - Database msdb cannot be opened

From AutoCount Resource Center
Revision as of 02:43, 27 July 2023 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


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:



By: Aimi 230707, Lay Swan 230713, P230721


Go to menu

AutoCount Accounting 2.0 & 2.1


AutoCount Accounting 1.8 / 1.9
AutoCount Payroll
AutoCount POS


AutoCount On The Go
AutoCount Accounting Plug-In Documentations