Azure Management Instance Business Critical

Question

Hi people,

I have two questions about SQL Management Instance Business Critical.

1 - When I activate Zone Redundancy, I can't select which redundancy zone I want one of the nodes to be in?

2 - When I have zone redundancy in a failover with Business Critical, I cannot shut down or restart the instance?

Answer 1

1 - When I activate Zone Redundancy, I can't select which redundancy zone I want one of the nodes to be in?

No - it's a managed service. It will distribute the instances automatically for you. Refer to https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/high-availability-sla?view=azuresql for details of this implementation

2 - When I have zone redundancy in a failover with Business Critical, I cannot shut down or restart the instance?

Correct - that's expected as well. As per https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/instance-stop-start-how-to?view=azuresql&tabs=azure-powershell-prep%2Cazure-portal#limitations-of-the-stop-and-start-feature

• You can't stop instances that:
  • Have an ongoing management operation (such as an ongoing restore, vCore scaling, and so on)
  • Are part of a failover group
  • Use the Managed Instance link
  • have zone redundancy enabled
  • are part of Instance pool

---

If the above response helps answer your question, remember to "Accept Answer" so that others in the community facing similar issues can easily find the solution. Your contribution is highly appreciated.

hth

Marcin