Checking your backups with tsql

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 *