1

A (hopefully) quick question - does enabling backup checksum default option affect VSS backups in any way?

Improve this question

1 Answer 1

Reset to default
2

This gives you a little bit of extra protection for your database backups, since the backup operation verifies each page for checksum and torn page, and generates a checksum for the entire backup. This is not a substitute for actually restoring you database backups on a regular basis, but it is a useful extra step to help ensure that your backups are actually good.

CHECKSUMs does not add too much CPU load but doing a VERIFYONLY does. There is no impact on vss snapshot creation.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.