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



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.


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


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


By: Aimi 220513, Lay Swan 220524, P220525


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