Configure zone redundancy - Azure SQL Managed Instance

Applies to: Azure SQL Managed Instance

This article teaches you to configure zone redundancy Azure SQL Managed Instance by using the Azure portal, PowerShell, Azure CLI, and REST API.

By using a zone-redundant configuration, you can make your Business Critical or General Purpose instances highly available and resilient to a much larger set of failures, including catastrophic datacenter outages, without any changes to the application logic. You can convert any existing Business Critical or General Purpose instances to the zone-redundant configuration.

Note

Zone-redundancy is currently in public preview for the General Purpose service tier.

Considerations

Consider the following when using zone redundancy for SQL Managed Instance:

• Zone redundancy is available in select regions.
• Zone redundancy is only available to instances that have enabled the November 2022 feature wave.
• Zone redundancy is currently in public preview for the General Purpose service tier and not currently available for the Next-gen General Purpose service tier.
• Zone redundancy can be enabled, and disabled. The operation to enable or disable zone redundancy is a fully online scaling operation executed in the background.
• To enable zone redundancy, your SQL managed instance Backup storage redundancy must use Zone-redundant or Geo-zone-redundant storage.

New instance

You can create a new zone-redundant instance by using the Azure portal, PowerShell, Azure CLI, and REST API.

Azure portal

To configure a new zone-redundant SQL managed instance in the Azure portal, follow these steps:

1. Go to the Azure SQL page in the Azure portal.

2. On the Azure SQL page, select + Create to open the Select SQL deployment option page.

3. On the Select SQL deployment option page, choose Single instance in the Resource type dropdown list on the SQL managed instances tile and then select Create to open the Create Azure SQL Managed Instance page.

4. On the Basics tab of the Create Azure SQL Managed Instance page, select Configure Managed Instance under Compute + storage to open the Compute + storage page.

5. On the Compute + storage page:

   1. For Backup storage redundancy under Backup, choose Zone-redundant or Geo-zone-redundant backup storage. Backups have to be configured before you can enable zone redundancy.
   2. For Zone redundancy under Compute Hardware, choose Enabled.
   3. Configure the remaining instance settings based on your business needs and then use Apply to save your configuration and go back to the Create Azure SQL Managed Instance page.

   

6. On the Create Azure SQL Managed Instance page, configure the remaining instance settings based on your business needs, select Review + Create to review your settings, and then use Create to deploy your instance configured with zone redundancy. For more information about deploying a managed instance, review Create Azure SQL Managed Instance.

PowerShell

To create a new zone-redundant SQL managed instance by using PowerShell, use the -ZoneRedundant switch when using the New-AzSqlInstance command. For a full PowerShell sample, review Create Azure SQL Managed Instance with PowerShell.

Omit -ZoneRedundant if you don't want your new SQL managed instance to be zone redundant.

Azure CLI

To create a new zone-redundant SQL managed instance by using the Azure CLI, set the --zone-redundant parameter to true when using the az sql mi create command. For a full Azure CLI sample, review Create Azure SQL Managed Instance with the Azure CLI.

Set --zone-redundant to false if you don't want your new SQL managed instance to be zone redundant.

REST API

To create a new zone-redundant SQL managed instance by using the REST API, set the zoneRedundant parameter to true when using the Managed Instances - Create Or Update command.

Set zoneRedundant to false if you don't want your new SQL managed instance to be zone redundant.

Existing instance

You can enable or disable zone redundancy for an existing SQL managed instance by using the Azure portal, PowerShell, Azure CLI, and REST API.

Azure portal

To update your zone redundancy configuration for an existing SQL managed instance by using the Azure portal, follow these steps.

1. Go to your SQL managed instance resource in the Azure portal.

2. On the Compute + storage pane:

   1. To enable zone redundancy, first ensure the Backup storage redundancy under Backup is set to Zone-redundant or Geo-zone-redundant. If it's not already, choose your new backup storage redundancy option and apply your settings. Wait for the operation to complete, and then refresh your page before enabling zone redundancy.
   2. Under Compute Hardware, use the Zone redundancy toggle to either enable or disable zone redundancy.

   

PowerShell

To update an existing SQL managed instance to be zone-redundant by using PowerShell, use the -ZoneRedundant switch when using the Set-AzSqlInstance command. For a full PowerShell sample, review Create Azure SQL Managed Instance with PowerShell.

Omit -ZoneRedundant if you want to disable zone redundancy for your existing SQL managed instance.

Azure CLI

To update an existing SQL managed instance to be zone-redundant by using the Azure CLI, set the --zone-redundant parameter to true when using the az sql mi update command. For a full Azure CLI sample, review Create Azure SQL Managed Instance with the Azure CLI.

Set --zone-redundant to false if you want to disable zone redundancy for your existing SQL managed instance.

REST API

To update an existing SQL managed instance to be zone-redundant by using the REST API, set the zoneRedundant parameter to true when using the Managed Instances - Update command.

Set zoneRedundant to false if you want to disable zone redundancy for your existing SQL managed instance.

Check zone redundancy

You can check the current zone redundancy setting for your SQL managed instance by using the Azure portal, PowerShell, Azure CLI, and the REST API.

Azure portal

To check the zone redundancy configuration for an existing SQL managed instance by using the Azure portal, follow these steps.

1. Go to your SQL managed instance resource in the Azure portal.
2. On the Compute + storage page under settings, check the Zone redundancy toggle in the Compute Hardware section.

PowerShell

To check the zone redundancy configuration for an existing SQL managed instance, validate the existence, or absence, of the Zone-redundant switch when using the Get-AzSqlInstance PowerShell command.

If the Zone-redundant switch is visible, zone redundancy is enabled.

Azure CLI

To check the zone redundancy configuration for an existing SQL managed instance, validate what the --zone-redundant parameter is set to when using the az sql mi show PowerShell command.

Zone redundancy is enabled if --zone-redundant is set to true.

REST API

To check the zone redundancy configuration for an existing SQL managed instance, validate what thezoneRedundant parameter is set to when using the Managed Instances - Get REST API command

Zone redundancy is enabled if zoneRedundant is set to true.

Supported regions

Zone redundancy for SQL Managed Instance varies for instances in the Business Critical and General Purpose service tier:

Business Critical service tier

Zone redundancy for Business Critical SQL Managed Instance is supported in the following regions:

Americas	Europe	Middle East	Africa	Asia Pacific
Brazil South	France Central	Qatar Central	South Africa North	Australia East
Canada Central	Italy North	Israel Central		Central India
Central US	Germany West Central			Japan East
East US	Norway East			Korea Central
East US 2	North Europe			Southeast Asia
South Central US	UK South			East Asia
West US 2	Sweden Central
West US 3	Switzerland North
	Poland Central

General Purpose service tier

Note

Zone-redundant configuration is in public preview for the General Purpose service tier.

Americas	Europe	Middle East	Africa	Asia Pacific
Brazil South	France Central	Qatar Central	South Africa North	Australia East
East US	Italy North	Israel Central		Central India
East US 2	Germany West Central			Japan East
South Central US	Norway East			Korea Central
West US 2	North Europe			Southeast Asia
West US 3	UK South			East Asia
	Sweden Central
	Switzerland North
	Poland Central

Related content

To learn more, review:

• High availability for Azure SQL Managed Instance
• Continuity scenarios
• Automated backups
• Restore a database from the service-initiated backups
• Failover groups
• Geo-restore