How to find a backup task by percentage complete
In this post, I will demonstrate how to track the completion of a backup task using a percentage indicator.
SELECT query = a.text, start_time, percent_complete,
eta = dateadd(second, estimated_completion_time/1000, getdate())
FROM sys.dm_exec_requests r
CROSS APPLY sys.dm_exec_sql_text(r.sql_handle) a
WHERE r.command LIKE 'BACKUP%'
For more related information, check out the following resources:
Find Databases Without Backup
Backup History Using T-SQL
Restore Database
