SQL Server: Script to find Estimated Finish Time of The Restore Database

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.

Anvesh Patel

Leave a Reply

1 Comment on "SQL Server: Script to find Estimated Finish Time of The Restore Database"

Notify of
avatar
Sort by:   newest | oldest | most voted
Major
Guest

Wow tht was strange. I just wrote an incredibly long comment but after I clicked
submit my comment didn’t sow up. Grrrr… well I’m not writing all that over again. Anyways, just wanted to say excellent blog!

wpDiscuz