Troubleshooting: Backup Error - Unknown Sql Exception (Number=9100, Message=Possible index corruption detected…..Could not insert a backup or restore history/detail record in the msdb database. This may indicate a problem with msdb

From AutoCount Resource Center

Question: When I want to backup the account book, this message prompted. What should I do? Unknown Sql Exception (Number=9100, Message=Possible index corruption detected. Run DBCC CHECKDB. Could not insert a backup or restore history/detail record in the msdb database. This may indicate a problem with msdb

Version: 1.8 / 1.9 / 2.0


Backup msdb1.png


Possible Reason:

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


Solution (1):

Copy the MSDB file from another pc to replace it.

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.

Backup msdb2.png


2) Copy the MSDBData and MSDBLog files from another PC and paste (replace) onto destination folder and START the SQL Services.

Backup msdb3.png

Backup msdb4.png


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


Solution (2):

Uninstall current Microsoft SQL Server and reinstall Microsoft SQL Server.


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(x86)\Microsoft SQL Server\MSSQL11_50.A2006\MSSQL\DATA

Backup msdb5.png


By: Aimi 220513, Lay Swan 220524, P220525


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