Azure SQL Managed instance question : I found an Azure SQL Managed Instance failover group that is set up between paired regions in the US. Currently, it is using the general tier and working well. However, I want to upgrade it to the business-critical tier. I've checked the Microsoft documentation, but it didn't provide the guidance I needed. So, I'm thinking about following some steps on my own. If you have any experience with a similar upgrade or if you foresee any potential issues, please let me know.
Upgrade to BC:
- Remove the failover group.
- Drop all databases from the secondary node. (one of prerequisite – secondary should be empty)
- Upgrade the secondary node to Business Critical.
- Upgrade the primary node to Business Critical. (Keep databases- Do not delete them)
- Join both regions as a failover group again.
Microsoft