Troubleshooting: Backup error - Backup Failed. Database Error found. Unknown Sql Exception ... A database snapshot cannot be created because it failed to start...

From AutoCount Resource Center
Jump to navigation Jump to search

Question : Why can’t I backup account book? There is an error message prompted ‘Backup Failed. Database Error found. Unknown Sql Exception .... A database snapshot cannot be created because it failed to start….”

Version : 1.8 / 1.9 / 2.0


Backup db snapshot.png


Possible Reason :

SQL server file may have corrupted.


Solution :

Uninstall and Re-install Microsoft SQL Server and re-attach the databases.

1) Go to Control Panel > Programs > Programs and Features.

2) Select your current Microsoft SQL Server 2012 (64-bit), right click and click on Uninstall/Change.


Backup db snapshot1.png


3) Click on Remove .


Backup db snapshot2.png


4) Click on OK.


Backup db snapshot3.png


5) Choose the instance that you want to remove, and click on Next.


Backup db snapshot4.png


6) You may choose Select All or may choose only A2006 (Database Engine Services and SQL Server Replication) to remove, then click on Next.


Backup db snapshot5.png


7) Let it finish running before proceeding with Next.


Backup db snapshot6.png


8) Under Ready to Remove, click on Remove.


Backup db snapshot7.png


9) Let the Remove Progress complete …


Backup db snapshot8.png


10) Uninstallation process is completed. You may click on Close.


Backup db snapshot9.png


11) After uninstall Microsoft SQL Server, please copy your AutoCount raw database (usually located at C:\AutoCount Data) and paste into another folder as a backup.

Then, you need to re-install the Microsoft SQL Server, please refer to the below link for the steps how to install.

Others: How to install SQL Server Express manually


12) After installed Microsoft SQL Server, install Microsoft SQL Server Management Studio, please refer to the below link for the steps how to install.

Others: How to install Microsoft SQL Management Studio


13) Then login SQL Management Studio to attach database. You need to attach back all your AutoCount raw databases. Please refer to the below link for the steps how to attach database.

Others: How to attach Database file from SQL Management Studio


14) After that, login AutoCount and you should be able to backup now.


Note : Please seek assistance from your software dealer if the problem still persists after performing the suggested steps.


By : Michelle 200416, Lay Swan 200423, P200428



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