Database integrity check failure

  • I've been getting the following error on a number of instances:

    Could not delete file 'E:\MSSQL15.INSTANCENAME\MSSQL\Data\DBNAME.mdf_MSSQL_DBCCXX'

    I can't find any further details in the SQL server error log.

    Can anyone advise? Thanks.

  • Hi,

    did you check, if the file exists on the drive?

    How about the permission on these folders, is the service account able to delete files in the folder?

    Kind Regards,

    Andreas

  • Hi Andreas

    Yes, the file does exist and the account is able to delete the DBCC snapshot file (which is what this is) for all the other databases in this folder.

    Peter

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply