Post reply

database corruption

  • February 29, 2012 at 10:11 pm

    #251628

    Do full backups run fine when db is corrupted?

  • March 1, 2012 at 1:23 am

    #1453477

    The backup option 'WITH CONTINUE_AFTER_ERROR' may work - it all depends upon the corruption.

    Why do you want to backup a corrupt database?

    Steve Hall
    Linkedin
    Blog Site

  • March 1, 2012 at 1:51 am

    #1453485

    I've seen backups succeed when the database has corruption in it. That's why it's important, periodically at least, to test that you can restore your databases and run DBCC CHECKDB on them.

    John

  • March 1, 2012 at 2:54 am

    #1453511

    Usually yes. For corruption to fail a backup requires that the corruption is really bad or in a critical area, or that backups are taken WITH CHECKSUM.

    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

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

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