SQLChicken.com

SQL Server DBA Tips & Tricks

By

Estimated Completion Time for Backups and Restores

I’m in the middle of a database migration and thought I’d quickly share a script I threw together to show estimated time of completion for a database restore in progress on SQL Server. The script will also show you estimated time for database backups to complete as well.

Please don’t take this script as gospel, the best way to truly know how long restores will take is to actually perform a restore! Remember folks:

Backups are worthless, restores are pricess

 

NOTE: Due to the fact this script uses DMV’s, will only work on SQL Server 2005 and higher

Share

One Response to Estimated Completion Time for Backups and Restores

  1. Renee Harner says:

    Really appreciate you sharing this blog.Really looking forward to read more. Much obliged.

Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">