Troubleshooting: Backup error – Backup Failed. Database Error found.. repair rebuild is the minimum repair level

From AutoCount Resource Center

Question: When I backup account book, error message prompted “Backup Failed. Database Error found.. repair_rebuild is the minimum repair level.” What should I do?

Version: 1.8 / 1.9 / 2.0


Possible Reason:

Database error but still able to repair the table.


Solution:

You may login Microsoft SQL Management Studio or AutoCount Management Studio. In this example we will use AutoCount Management Studio.

1) Login AutoCount Management Studio > Tools > SQL Query > click on YES.

2) Execute the below query one by one.

Query 1:

ALTER DATABASE yourDBname SET SINGLE_USER WITH ROLLBACK IMMEDIATE
and click on Execute.


Query 2:

DBCC CHECKDB ('yourDBname', REPAIR_REBUILD)
and click on Execute.

You may need to execute again for the same query until the result is 0 allocation errors 0 consistency errors.



Query 3:
ALTER DATABASE yourDBnameSET MULTI_USER


3) Now your account book should be able to backup successfully.


By: Aimi 220412, Lay Swan 220425, P220428


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