The operation could not be completed because a service tier change is in progress for managed instance 'xxxxxxxx'.

Question

I have a SQL server managed Instance and trying to make a copy of exiting database on same managed instance using restore operation but getting error --

"The operation could not be completed because a service tier change is in progress for managed instance 'ManagedInstanceName' Please wait for the operation in progress to complete and try again"

Answer 1

It sounds like a service tier change is currently in progress on your Azure SQL MI (Managed instance). This can temporarily prevent other operations, such as restoring a database.

You can opt to wait for the operation to complete. You can check the status of the service tier change operation in the Azure portal. After confirming that the service tier change is complete, try the restore operation again.

If the service tier change seems stuck or takes an unusually long time, consider reaching out to Azure Support for further assistance.