How monitor PITR restore in Managed Instance
Published Oct 29 2022 10:17 AM 2,942 Views
Microsoft

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

Co-Authors
Version history
Last update:
‎Oct 29 2022 10:22 AM
Updated by: