This article is contributed. See the original author and article here.

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.-

Brought to you by Dr. Ware, Microsoft Office 365 Silver Partner, Charleston SC.