How to Get Estimated Completion Time of SQL Server Database Backup OR Restore

“How much time SQL Server is going to take to complete the database Backup or Restore” – This is one of the very common questions DBAs face in day to day life when they are performing database refresh activity, database migration activity, or any adhoc activity where DBA may want to have a DB backup before the activity takes place.

In this tip, we will explore a very simple script to get the estimated amount time which SQL Server is going to take to complete database Backup or Restore. You may find the below script very useful when we are dealing with the very large database.

This is how the output looks like;

Hope, you find this script useful to answer the question.

Keep Learning!

7 thoughts on “How to Get Estimated Completion Time of SQL Server Database Backup OR Restore

  • gerald

    yes, great – and I’m using it since ages… slightly adapted

    Reply
    • Dharmendra
      Dharmendra

      Thanks Gerald! glad to hear that 🙂

      Reply
  • Erick muchina

    The materials are very useful

    Reply
    • Dharmendra
      Dharmendra

      Thank you Erick for your valuable feedback!

      Reply
  • Anne

    Thanks for the scripts. But I run on my a couple of servers, and returns no record.
    Does this only work on manually run backup or restore?
    I do have nightly backup, it does not shown.

    Reply
  • Anne

    I did not see the comments I posted. If it is a duplicated, please pardon me.
    I ran the scripts, but nothing returned on a couple of servers. I do have backup scheduled nightly.
    Does this script show the nightly backup completion time? Thanks

    Reply
    • Dharmendra
      Dharmendra

      Thanks Anne for your input! It works for all kind of backups/restore like the backup is being taken by SQL Job or any other tool like DPM, LiteSpeed etc. It only shows when backup or restore is running on the server. When you ran the script, was there backup or restore running on the server?

      Reply

Leave a comment

Your email address will not be published. Required fields are marked *