How to estimate when a restore will complete? (4225119)

How to estimate when a restore will complete?

WORKAOUND:
The script will also show you estimated time for database backups to complete as well.

Please don’t take this script as gospel, the best way to truly know how long restores will take is to actually perform a restore! Remember folks:  Backups are worthless, restores are pricless

SELECT
	session_id,
	start_time,
	status,
	command,
	percent_complete,
	estimated_completion_time,
	estimated_completion_time /60/1000 as estimate_completion_minutes,
	--(select convert(varchar(5),getdate(),8)),
	DATEADD(n,(estimated_completion_time /60/1000),GETDATE()) as estimated_completion_time

FROM    sys.dm_exec_requests where command = 'BACKUP DATABASE' OR command = 'RESTORE DATABASE'

NOTE: Due to the fact this script uses DMV’s, will only work on SQL Server 2005 and higher

The original source is http://www.sqlservercentral.com/blogs/sqlchicken/2011/12/30/estimated-completion-time-for-backups-and-restores/

This script has not been tested or verified.