View source for 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.

'''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

[[File:Backup dbcc1.png]]


<u><b>Possible Reason :</b></u>

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.


<u><b>Solution :</b></u>

<span style='color:red'>Rename the file name</span> or <span style='color:red'>change the file path</span>.<br/>

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

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.

[[File:Backup dbcc2.png]]


3)	Click Continue.

[[File:Backup dbcc3.png]]


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

[[File:Backup dbcc4.png]]


By: Aimi 210813, Lay Swan 210827, P210827


{{NavigateForUser}}

[[Category:Users]]