question

Wilfred van Dijk avatar image
Wilfred van Dijk asked

Questions about backup and verify

It seems I cannot check if a verify was performed after a backup was made. There's a column for using CHECKSUMS but not for verify, correct? Any other options? If a backup seems to be ok, but the verify failed, is this backup still registered in MSDB? (never had this situation)
backupmsdb
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Grant Fritchey avatar image
Grant Fritchey answered
the verify is independent of the backup itself. So yeah, if the backup completes, it'll be in MSDB even if the verify fails.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.