Azure managed instance still updating after scale operation started 5 days ago

Question

I scaled a general purpose managed instance several days ago , but on the overview page for the managed instance,, it is still displaying the following message , 'The resource is still updating please do not create restore databases etc' this is shown on the overview page for the managed instance, the upgrade was kicked off a week ago, Why is still displaying resource is still updating?

Answer 1

Hello Redington, Tom,

Thanks for your question.

It should typically take 45-60 mins, if its taking a week then something is definitely wrong.

Get the status of the operation using Powershell:

Get-AzSqlInstanceOperation -ResourceGroupName "RG" -InstanceName "instance"

https://learn.microsoft.com/en-us/powershell/module/az.sql/get-azsqlinstanceoperation?view=azps-12.5.0

This will give better details about why this is happening.You can also go to Monitor > Activity Log to view events

See: https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/management-operations-overview?source=recommendations

You can mark it 'Accept Answer' and 'Upvote' if this helped you

Regards,

Abiola