Check progress of SQL Server restore

Posted by Joe Enos on March 27, 2021 · 1 min read

From MSSQLTips:

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')