SELECT r.session_id as SPID,
r.command,
a.text AS Query,
r.start_time,
r.percent_complete,
dateadd(second,estimated_completion_time/1000, getdate()) as estimated_completion_time
FROM sys.dm_exec_requests r
CROSS APPLY sys.dm_exec_sql_text(r.sql_ handle) a
WHERE r.command = 'BACKUP DATABASE'
No comments:
Post a Comment