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.

Please share your ideas and opinions about this topic with me, your contribution will add true value to this topic.
If anyone has doubts on this topic then please do let me know by leaving comments or send me an email.

If you like this post, then please share it with others.
Please follow dbrnd.com, I will share my experience towards the success of Database Research and Development Activity.

I put up a post every day, please keep reading and learning.
Discover Yourself, Happy Blogging !
Anvesh M. Patel.

More from dbrnd.com

Leave a Reply

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

Notify of
Sort by:   newest | oldest | most voted

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!