backup

If you want to see more than just when the last backup occurred. Here is a script for backup history with two bonus features. Backup compression ratio - CompressionRatio Backup…

This script will show when the last backup occurred as well as the backup type for each database. This covers all the backup types available and pivots the output into…