Restore VERIFYONLY vs RESTORE HEADERONLY WITH CHECKSUM

  • oogibah

    SSC Eights!

    Points: 802

    I have a combination sql/powershell script I've been using to do restore headeronly to verify the LSN chain is intact and it alerts if there is a break in it.  I was having it run after each log backup but these were bumping into each other and causing problems, so I'm moving to do one at the end of the day.  I see a lot of people recommend using verifyonly because it does the checksum when you do this, is the WITH CHECKSUM on restore HEADERONLY different?  If so is it less good?

Viewing post 1 (of 1 total)

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