Backup 및 Restore 진행현황 쿼리

Backup , Restore 진행현황을 %로 보여줌

SELECT session_id as SPID, command, a.text AS Query, start_time, 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 in ('BACKUP DATABASE','RESTORE DATABASE');