Checking your backups with tsql

01_Vault_101_Citizenship_Award

Pipboy level utility!

Here is a script I like to run each morning against my central management server groups.  Original credit goes somewhere, I forgot to bookmark where, so apologies if you feel ripped and bitter.

I modified the script to check for both differential and full backups, added size of the backup, and added the path the backup was saved to.

Cheers

CheckBackups.sql

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.