Jon Gurgul's Blog

Tag: backup

  • Backup History

    —

    by

    Jon Gurgul
    in

    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 speed – Backup_MiB_S

  • Last Backup Occurred

    —

    by

    Jon Gurgul
    in

    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 a simple and easily readable format. It will state the reason; if any, for log reuse wait and the database recovery model in use. Depending…