How Much More Time Until That Backup/Restore is Done?
Eric Russo | | July 13, 2010

SQL Server Database Administrators always get to hear the age old question: How much longer will that restore or backup take? We’ve always answered this question based on past experiences along with some educated “guestimations.”
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)))FROM sys.dm_exec_requests r
WHERE command IN(‘RESTORE DATABASE’,’BACKUP DATABASE’)
Subscribe to Our Blog
Never miss a post! Stay up to date with the latest database, application and analytics tips and news. Delivered in a handy bi-weekly update straight to your inbox. You can unsubscribe at any time.
Popular Posts
ORA-12154: TNS:could not resolve the connect identifier specified
Most people will encounter this error when their application tries to connect to an Oracle database service, but it can also be raised by one database instance trying to connect to another database service via a database link.
12c Upgrade Bug with SQL Tuning Advisor
Learn the steps to take on your Oracle upgrade 11.2 to 12.1 if you’re having performance problems. Oracle offers a patch and work around to BUG 20540751.
Scripting Out the Logins, Server Role Assignments, and Server Permissions
Imagine over 100 logins on the source server, you need to migrate them to the destination server. Wouldn’t it be awesome if we could automate the process?