How to monitor backup and restore progress in SQL Server

Below script can give us a summary of current backups and restores which are happening on the server:

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19

SELECT r.session_id AS [Session_Id]     ,r.command AS [command]     ,CONVERT(NUMERIC(6, 2), r.percent_complete) AS [% Complete]     ,GETDATE() AS [Current Time]     ,CONVERT(VARCHAR(20), DATEADD(ms, r.estimated_completion_time, GetDate()), 20) AS [Estimated Completion Time]     ,CONVERT(NUMERIC(32, 2), r.total_elapsed_time / 1000.0 / 60.0) AS [Elapsed Min]     ,CONVERT(NUMERIC(32, 2), r.estimated_completion_time / 1000.0 / 60.0) AS [Estimated Min]     ,CONVERT(NUMERIC(32, 2), r.estimated_completion_time / 1000.0 / 60.0 / 60.0) AS [Estimated Hours]     ,CONVERT(VARCHAR(1000), (             SELECT SUBSTRING(TEXT, r.statement_start_offset / 2, CASE                         WHEN r.statement_end_offset = - 1                             THEN 1000                         ELSE (r.statement_end_offset - r.statement_start_offset) / 2                         END) 'Statement text'             FROM sys.dm_exec_sql_text(sql_handle)             )) FROM sys.dm_exec_requests r WHERE command like 'RESTORE%' or  command like 'BACKUP%'

Source:

https://blog.sqlauthority.com/2017/03/12/get-status-running-backup-restore-sql-server-interview-question-week-113/