In this post, I am providing a SQL Script to find Estimated Finish Time for the action of SQL Server Restore Database.
When I am doing any action like backup and restore, every time I keen to know the estimated completion time.
This is also one of the important information for a organization and related clients to take decision for maintenance time.
Using SQL Server sys.dm_exec_requests, we can estimate the finish time. We can also populate completed and estimated percentage.
You can execute below query while the Database Restore is running. You can find a record like RESTORE COMMAND.
,percent_complete AS CompletedPercent
,DATEADD(MILLISECOND,estimated_completion_time,CURRENT_TIMESTAMP) AS EstimatedFinishTime
,(total_elapsed_time/1000)/60 AS TotalElapsedTimeInMIN
,DB_NAME(Database_id) AS DatabaseName