Raise alerts based on backup size
I'd like to be able to detect if differential and log backups are becoming too large. This could indicate that a lot of changes have been occurring and perhaps we ought to run a full backup soon (or more frequent transaction log backups).
For one, if the size of the differential is greater than the size of the full. Meanwhile, transaction logs could be more of a "relative to the last X backups over the last Y amount of time".
1
vote