Home > Uncategorized > Backup/Restore Time Estimations

Backup/Restore Time Estimations

Often times I have seen people run through the GUI in SSMS to perform backup or restore operations only to see the spinning wheel and not knowing how much longer or what percentage complete the command is at.  I stumbled across this script a few years ago and use it quite often to determine time left for a command and percentage complete.  It also works for other operations such DBCC CHECKDB.


use master
go

SELECT
percent_complete,
start_time ,
command,
b.name AS DatabaseName,
DATEADD(ms,estimated_completion_time,GETDATE()) AS RemainTime,
(estimated_completion_time/1000/60) AS MinutesToFinish
FROM sys.dm_exec_requests a
INNER JOIN sys.databases b
ON a.database_id = b.database_id
WHERE command like '%restore%'
or command like '%Backup%'
AND estimated_completion_time > 0

Advertisements
Categories: Uncategorized
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: