THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » backup » predicting duration   (RSS)
  • When will my backup / restore / index reorganize finish?

    The DMVs are a great way to get a closer look at what is actually going on in your system.  In particular, for some operations, SQL Server populates the percent_complete and estimated_completion_time (in milliseconds) in the DMV sys.dm_exec_requests.  This can be very useful if you want to know how long your BACKUP or RESTORE will take ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on July 30, 2009
Privacy Statement