Home Forums Article Discussions Article Discussions by Author Discuss content posted by Ian Stirk A faster DBCC CHECKDB? RE: A faster DBCC CHECKDB?

  • June 18, 2014 at 11:13 am

    #1722907

    Paul Randal (6/18/2014)

    No - running DBCC CHECKDB on any copy of the database that is maintained by SAN replication, log shipping, mirroring, etc is not good enough. That tells you nothing about the I/O subsystem on the main system. Only doing a full backup+copy+restore is a substitute for DBCC CHECKDB on the main server.

    Cheers

    Thanks. While i have your attention here, does DBCC cause any blocking?