Get Backup/Restore operations with completion times

get-backup-restore-completion.sql

SELECT
	session_id, command, start_time, percent_complete, 
    estimated_completion_time AS estimated_completion_time_ms, 
    estimated_completion_time / (1000 * 60) AS estimated_completion_time_min
FROM
	sys.dm_exec_requests
WHERE
	command IN ('BACKUP DATABASE', 'BACKUP LOG', 'RESTORE DATABASE', 'RESTORE LOG', 'RESTORE HEADERONLY', 'RESTORE FILELISTONLY')
ORDER BY estimated_completion_time;