Created
June 21, 2017 09:39
-
-
Save adrianvlupu/ae24b0c24e74741c3b52661a63d9e502 to your computer and use it in GitHub Desktop.
MSSQL backup progress
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT command, | |
s.text, | |
start_time, | |
percent_complete, | |
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, | |
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, | |
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') |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment