Friday, May 16, 2025

View Resource Changes in a SQL Managed Instance

 

My coworker resolved a storage issue with one of our managed instances.  To see what he did, I went to the Azure portal, viewed the managed instance and went to “Activity Log”.

In the activity log, it will show you what has been changed in the managed instance.  Azure groups the operations, so you would have to expand the operation to see what has happened.

 

A screenshot of a computer

AI-generated content may be incorrect.

I clicked the last entry, the one that says “Succeeded”.

A dialog will pop up on the right side of the page.  This will show what the actual change was.


A screenshot of a computer

AI-generated content may be incorrect.

 

In this case, he has changed the storage value from 160 GB to 256 GB.

And we can verify this on the “Overview” or “Compute + storage” sections.

A screenshot of a data storage

AI-generated content may be incorrect.

 

A screen shot of a computer

AI-generated content may be incorrect.

 

 


Checking Backup File Date Before Restoring

 Today, I got an interesting request.  I had to check a restore job for a data warehouse analyst.  He said the database wasn't restored ...