DBCC Job Failed with Error “Cannot create file because it already exists” – Solved

When running DBCC checks on a database the process is actually carried out on a snapshot of the database. This works well and helps to ensure that there are no problems with blocking or transaction consistency. The problem is that if your server gets restarted whilst DBCC checks are in progress files can get left…

Continue reading →