Post reply

Backup/restore

  • December 7, 2009 at 10:04 am

    #385901

    Hi gurus,

    what happens if you try to restore the DB, but incidentally you don't know that the backup file is corrupted, will sql server still do the restore and corrupt the entire database or will it stop with an error message?

  • December 7, 2009 at 10:22 am

    #1088712

    Depends on the type and severity of the corruption. Either's possible.

    If the database has checksum page protection and the backup was done with the checksum option, then many forms of database corruption would be detected at backup time and any damage to the backup file will be detected by the restore and the restore will fail.

    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 2 posts - 1 through 1 (of 1 total)

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