How monitor PITR restore in Managed Instance

This post has been republished via RSS; it originally appeared at: Azure Database Support Blog articles.

When you start a PITR restore in your Managed Instance, is very useful be able to track how it progresses. Azure Portal does not show too many details about it, but we can use Managed Instance logs to track it. 

 

The way to do it, is quite simple. You just need to connect to your MI using your SSMS (SQL Server Management Studio) and open "SQL Server Logs" that you will find under "Management"

 

Palomag_MSFT_0-1667062573486.png

 

 After open logs, is the time to filter then to be focus on the recovery process. 

 

Palomag_MSFT_1-1667062707819.png

After applying the filter, you will be able to track restore progression. 

 

Palomag_MSFT_2-1667063239155.png

 

Simple and effective

 

Enjoy. - 

 

Paloma.-

Leave a Reply

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

*

This site uses Akismet to reduce spam. Learn how your comment data is processed.