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

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 2.0 What's New AutoCount Accounting 2.0 Help File AutoCount Accounting 2.0 FAQ (Application) AutoCount Accounting 2.0 FAQ (Troubleshoot) AutoCount Accounting 2.0 Others AutoCount Accounting 2.0 Release Note AutoCount Accounting 2.1 Release Note

AutoCount Accounting 1.8 / 1.9 AutoCount Accounting 1.8 FAQ (Application) AutoCount Accounting 1.8 FAQ (Troubleshoot) AutoCount Accounting 1.8 / 1.9 Release Note

AutoCount Payroll

AutoCount POS

AutoCount On The Go

AutoCount Accounting Plug-In Documentations