Get time for restore or backup a database

SELECT percent_complete,

       CAST((estimated_completion_time/3600000) AS varchar) + ' hour(s), ' + CAST((estimated_completion_time %3600000)/60000 AS varchar) + 'min, ' + CAST((estimated_completion_time %60000)/1000 AS varchar) + ' sec' AS est_time_to_go,

       command,

       s.text,

       start_time,

       CAST(((DATEDIFF(s,start_time,GetDate()))/3600) AS varchar) + ' hour(s), ' + CAST((DATEDIFF(s,start_time,GetDate())%3600)/60 AS varchar) + 'min, ' + CAST((DATEDIFF(s,start_time,GetDate())%60) AS varchar) + ' sec' AS running_time,

       dateadd(SECOND,estimated_completion_time/1000, getdate()) AS est_completion_time

FROM sys.dm_exec_requests r CROSS APPLY sys.dm_exec_sql_text(r.sql_handle) s

WHERE r.command IN ('RESTORE DATABASE',

                    'BACKUP DATABASE',

                    'RESTORE LOG',

                    'BACKUP LOG',

                    'RESTORE HEADERON')