SQL Server / Monitor Backup and Restore progress

Recently I had a situation on QA environment where Backup and Restore took a long time to finish.

It was HA environment with two nodes in Always On High Availability Group, so backup and restored occurred over network shared location.

Drives were slow, database was huge and network latency not the best  so it took a long time to add database to the availability group.

To follow up backup or restore progress with start time, total elapsed time and estimated completion time in similar situation you can use following script

 

You can follow up percent complete in results pane

 

Be aware that the restore can stuck close to the end around 99%, if database is large it may take some additional times (even couple hours) for recovery to complete.

To understand better how restore and recovery process works you can read this Microsoft article
Understanding How Restore and Recovery of Backups Work in SQL Server

 

 

Similar Posts:

Leave a Reply

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