Database Restore Progress in SQL Server

Database Restore Progress in SQL Server

This post will takes you through you monitoring Database Restore Progress in SQL Server. Here we have an useful script which can help us in the process of restoration of databases. As we are restoring the databases on daily basis of size ranging from 1 GB to 1TB files ,we would like to know the exact percentage completed , and estimated time to complete. The below script retrieves those details which can help us in further proceedings.

T-SQL Script to Monitor Database Restore Progress in SQL Server: 

We have initiated a restore and ran this query it shows the status as below

After a few minutes

 

 

Posted in Uncategorized | Tagged , , , , , , , , , | 1 Comment

Leave a Reply

1 Comment on "Database Restore Progress in SQL Server"

Notify of
avatar
Sort by:   newest | oldest | most voted
Prem Reddy
Guest

Nice article and itwas helpful

wpDiscuz