Blog Pages

Get current database backups

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