/SQL/Check database restore status sql script

Check database restore status sql script

SELECT r.session_id,r.command,CONVERT(NUMERIC(6,2),r.percent_complete)
AS [Percent Complete],CONVERT(VARCHAR(20),DATEADD(ms,r.estimated_completion_time,GetDate()),20) AS [ETA Completion Time],
CONVERT(NUMERIC(10,2),r.total_elapsed_time/1000.0/60.0) AS [Elapsed Min],
CONVERT(NUMERIC(10,2),r.estimated_completion_time/1000.0/60.0) AS [ETA Min],
CONVERT(NUMERIC(10,2),r.estimated_completion_time/1000.0/60.0/60.0) AS [ETA 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)
FROM sys.dm_exec_sql_text(sql_handle))) AS [SQL]
FROM sys.dm_exec_requests r WHERE command IN ('RESTORE DATABASE','BACKUP DATABASE')

Source: stackoverflow.com

Similar codes

12 votes196 views6 answers
Distinct in sql server
SQL
0 vote172 views2 answers
Pg_restore: error: input file appears to be a text format dump. Please use psql.
SQL
2 votes178 views1 answer
Drop all database tables oracle sql developer
SQL
4 votes166 views1 answer
Mysql insert from local csv
SQL
0 vote177 views1 answer
Change date format in oracle query
SQL
5 votes183 views3 answers
Bash: mysql: command not found
SQL
0 vote169 views1 answer
Postgresql alter column nullable
SQL
1 vote183 views1 answer
What is int in mysql
SQL
-3 votes175 views2 answers
How to enable mysql authentication on ubuntu 18.04
SQL
25 votes160 views4 answers
Metadata
SQL