TO FIND HOW MUCH % BACKUP COMPLETED?
SELECT command, percent_complete,
'elapsed' = total_elapsed_time /
60000.0,
'remaining' =
estimated_completion_time / 60000.0
FROM sys.dm_exec_requests
WHERE command like 'BACKUP%'
No comments:
Post a Comment