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 act like backup and restore, I keen to know the estimated completion time.
This is also one of the valuable information for 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.

Anvesh Patel

Leave a Reply

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

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

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.

erna
Guest

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

leo
Guest

Keep on working, great job!

wpDiscuz