get_estimated_backup_restore_time.sql

-- Get estimated backup & restore time
SELECT
	r.session_id,
	r.user_id,
	r.start_time,
	dateadd(second,estimated_completion_time/1000, getdate()) as estimated_completion_time,
	r.percent_complete,
	r.command,
	d.name,
	s.text AS full_command_text
FROM sys.dm_exec_requests r
JOIN sys.databases d ON r.database_id = d.database_id 
CROSS APPLY sys.dm_exec_sql_text(r.sql_handle) s 
CROSS APPLY sys.dm_exec_input_buffer(r.session_id, r.request_id) AS ib
WHERE 1=1
AND r.command IN (
    'RESTORE DATABASE', 
    'BACKUP DATABASE', 
    'RESTORE LOG', 
    'BACKUP LOG', 
    'DbccSpaceReclaim',
    'DbccFilesCompact');