Post reply

DBCC checkdb - does it spread to other pages?

  • June 9, 2015 at 10:50 pm

    #318766

    I do understand database corruption is bad, does it matter if the corruption is detected right away or after a week? I mean does the corruption spread to other pages?

  • June 10, 2015 at 1:33 am

    #1804230

    Yes, it matters, but not because it's contageous (it's not)

    It matters because after a week or two or a month or ... you may not have the backups you need to be able to restore without data loss.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • June 10, 2015 at 7:58 am

    #1804348

    Thanks. Looks like i cannot prevent corruption but may be able react quickly.

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

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