[MSSQL] (Backup, Restore) Database 진행률 확인 쿼리

BACKUP DATABASE 진행률 확인 쿼리

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 = 'BACKUP DATABASE'

 

RESTORE Database 진행률 확인 쿼리

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 = 'RESTORE DATABASE'