Home Forums SQL Server 2005 Backups Ideas on a backup that "fails" but Verify says it is good RE: Ideas on a backup that "fails" but Verify says it is good

  • June 11, 2013 at 7:17 am

    #1622901

    Ellen-477471 (6/11/2013)

    Lately on some of our backups the job will return a message that the backup failed but when I check to rerun the job there will exist a backup file [or files] and when I run the backup "Restore" statements against the file it says the backup is good.

    Below is the log from the latest backup failure and the return statement from the verification.

    I am curious if others have had this issue and if I should trust the backup or not.

    The only thing that verify checks (if you didn;t do the backup with checksum) is the backup header and some metadata and a bit of the start of the backup. A backup can verify successfully and fail to restore.

    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