DBCC CHECKDB Returns Different Consistency Errors on Subsequent Runs

• skreebydba

  SSChasing Mays

  Points: 646

  More actions

  October 23, 2014 at 7:50 am

  #312474

  We have restored a database to SAN storage as part of a migration. A scheduled run of DBCC CHECKDB failed after the restore. Repeated runs of DBCC CHECKDB are returning different results. Each run returns consistency errors, but the consistency errors show up on different pages and allocation units. When the database is restored to local storage, DBCC CHECKDB comes back clean. That points me to an issue with the SAN, but I am very confused by the changing DBCC CHECKDB results. Has anyone seen behavior like this before?

  Thanks,

  Frank

• skreebydba

  SSChasing Mays

  Points: 646

  More actions

  October 23, 2014 at 8:15 am

  #1754359

  Additional information:

  The database is 423GB.

  It contains one data file, one fulltext file, and one log file.

  Three smaller databases on the SAN do not show corruption.

  Let me know if additional information is needed.