Troubleshooting: Backup Error – Cannot create file ‘C:\AutoCount Data\xxx Data.mdf MSSQL DBCC9’ because it already exists. Change the file path or the file name, and retry the operation.

From AutoCount Resource Center
Revision as of 02:15, 30 August 2021 by LaySwan (talk | contribs) (Created page with "'''Question:''' When I try to backup, system prompted error ‘Backup Failed. Database Error found. Unknown Sql Exception Cannot create file ‘C:\AutoCount Data\xxx_Data.mdf_...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Question: When I try to backup, system prompted error ‘Backup Failed. Database Error found. Unknown Sql Exception Cannot create file ‘C:\AutoCount Data\xxx_Data.mdf_MSSQL_DBCC9’ because it already exists. Change the file path or the file name, and retry the operation.

Version: 1.8/ 1.9 / 2.0

Backup dbcc1.png


Possible Reason :

Your server being shut down or reboot while backup was in progress (run of the DBCC CHECKDB task). Now when you perform backup, there is a file that causing duplicate conflict.


Solution :

Rename the file name or change the file path.

1) Using file explorer, navigate to the file location show in the backup error. (C:\AutoCount Data)

2) You may rename the file name or move the file to another path. To move, cut the file and paste it into another path.

Backup dbcc2.png


3) Click Continue.

Backup dbcc3.png


4) Now you should be able to backup your data.

Backup dbcc4.png


By: Aimi 210813, Lay Swan 210827, P210827



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