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 when you need to communicate realistic timelines.
If you want a deeper explanation of how SQL Server calculates these estimates and related behaviours, see Estimate Backup and Restore Completion Time in SQL Server.
The Script
Example Output
The result set shows one row per active backup or restore operation, including percent complete, running time, estimated remaining time, and expected completion time.
Notes
- Only returns results while a supported operation is actively running
- Estimated completion time can fluctuate during the operation
- Particularly useful during restores when stakeholders are waiting for updates
- Works for both backup and restore operations
Leave a Reply