Restore VERIFYONLY vs RESTORE HEADERONLY WITH CHECKSUM

  • 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 0 posts

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