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

In this post, I am providing a SQL Script to find Estimated Finish Time for the action of the SQL Server Backup 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 Backup is running. You can find a record like BACKUP 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

3 Comments on "SQL Server: Script to find Estimated Finish Time of The Backup Database"

Notify of

Sort by:   newest | oldest | most voted
9 months 20 days ago

I’m extremely impressed with your writing skills as well as with the layout on your blog.
Is this a paid theme or did you customize it yourself?
Anyway keep up the nice quality writing, it is rare to see a great blog
like this one today.

9 months 19 days ago

I constantly spent my half an hour to read this webpage’s articles or
reviews every day along with a cup of coffee.

9 months 18 days ago

Keep on working, great job!