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
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
AutoCount Accounting 1.8 / 1.9
|
AutoCount Payroll
|
AutoCount POS
|
AutoCount On The Go
|
AutoCount Accounting Plug-In Documentations
|