Corrupt Backup - Where can i find the flags/log to say a backup was verified?

  • Maint plan - always have verify backup ticked. Restore error message corrupt header. How can i tell that the backup was verified sucessfully?

    is there a flag in table backupset? nothing in the log that i can find. I am at the mo running RESTORE VERIFYONLY FROM DISK= on 300Gb db so not sure how long it will take!

    Oraculum

  • You may check msdb.dbo.backupset. There columns like 'is_damaged' may help you.

    DBDigger Microsoft Data Platform Consultancy.

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

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