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

Repair rebuild1.png


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.

Repair rebuild2.png


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.

Repair rebuild3.png


Repair rebuild7.png


Query 3:
ALTER DATABASE yourDBnameSET MULTI_USER

Repair rebuild5.png


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

Repair rebuild6.png


By: Aimi 220412, Lay Swan 220425, P220428


Go to menu

IconAcc20.PNG AutoCount Accounting 2.0


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