/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

3 votes325 views3 answers
Mysql auto increment after delete
SQL
0 vote308 views1 answer
Sqlites studio red exclamation mark when poening databse
SQL
9 votes301 views1 answer
Mysql check date range
SQL
4 votes254 views2 answers
Access to dialectresolutioninfo cannot be null when 'hibernate.dialect' not set
SQL
0 vote288 views1 answer
Error-expression-select-list-not-group-by-nonaggregated-column/
SQL
8 votes295 views1 answer
Declare table variable sql server
SQL
11 votes302 views1 answer
Oracle insert into where
SQL
11 votes284 views2 answers
Docker create postgres db
SQL
36 votes319 views6 answers
Delete from where sql
SQL
0 vote304 views1 answer
Sparql if bound query
SQL