Post reply

Backup Check

  • March 11, 2015 at 8:01 am

    #301952

    Hi all,

    How to check whether the backup got corrupted or not?

    Regards
    Chowdary...

  • March 11, 2015 at 8:16 am

    #1783301

    Restore it to another server. If the restore succeeds, the backup is undamaged.

    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

  • March 11, 2015 at 12:11 pm

    #1783418

    Here's an article[/url] I wrote on the various mechanisms and what each one does for you. The best is what Gail says, restore the database.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

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

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