Menu & Search
Get Estimated Database Restore Time

Get Estimated Database Restore Time


If you’re backing up or restoring a large database, you can run the script below to find out how long it has left to complete.

The performance of a backup or restore will depend on many things such as server hardware, chosen backup options or even a user running queries. The estimated time returned by the query below is based on the performance at the time of execution.

As a quick alternative, you can also use sp_whoisactive to gain a rough idea of progress by viewing the percent_complete column.