Category: Backups and Recovery

DBA scripts for validating backups, restores, recovery models, and disaster recovery readiness.

  • Script: Estimate Backup and Restore Completion Time

    This script shows the current progress and estimated completion time for running backup and restore operations. It’s intended to be used while an operation is already in progress, giving a clear view of how long it has been running and how much time is likely remaining. This is especially useful during incidents or maintenance windows…

  • Script: Check Backup Coverage Across All Databases

    This script returns the most recent full, differential, and transaction log backup times for every database on a SQL Server instance. It’s designed as a quick sanity check to validate backup coverage, identify gaps, and confirm maintenance jobs are running as expected across an environment. The Script Example Output The result set shows one row…