Database integrity check

• sqlfriend

  SSC Guru

  Points: 52794

  More actions

  April 1, 2019 at 4:36 pm

  #2382922

  I have a question about the IntegrityCheck job that I used OLA Hallengren's maintainance solution.

  I see the job failed with error in log:

  Message

  Cannot create file 'E:\MSSQL\DATA\mydb.mdf_MSSQL_DBCC13' because it already exists. Change the file path or the file name, and retry the operation.

  Error: 5170, Severity: 16, State: 1.

  I did some search, it seems when doing DBCC it creates a snapshot of database. Our db is 300 GB.

  And the mydb.mdf_MSSQL_DBCC13 created on the drive is 150 GB.

  I wonder if it failed because the space issue or some other reason?

  Does the snapshot need the same space of the original db, if so that will be a lot.

  How can I fix this error

• Sue_H

  SSC Guru

  Points: 90860

  More actions

  April 1, 2019 at 6:48 pm

  #2396189

  With the error being that the snapshot already exists, it seems like it may be trying the integrity check twice and they overlap.

  Possibly you are specifying the database database more than once either in the script itself or maybe you have more than one integrity check process, job and the database is specified in both. Something along those lines.

  Sue

• sqlfriend

  SSC Guru

  Points: 52794

  More actions

  April 1, 2019 at 6:49 pm

  #2396354

  Thanks, I found the reason is because during a week ago job run, there is a windows update reboot server that interupts the DBCC.

  Got fixed

  Thanks,