Skip to content

instance-zone-redundancy-configure.md

Latest commit

 

History

History
154 lines (92 loc) · 10.3 KB

instance-zone-redundancy-configure.md

File metadata and controls

154 lines (92 loc) · 10.3 KB
title Configure Zone Redundancy
description Configure zone redundancy for your Azure SQL Managed Instance by using the Azure portal, PowerShell, Azure CLI, and REST API.
author Stralle
ms.author strrodic
ms.reviewer urmilano, mathoma, randolphwest
ms.date 09/11/2025
ms.service azure-sql-managed-instance
ms.subservice high-availability
ms.topic how-to
ms.custom
sfi-image-nochange

Configure zone redundancy - Azure SQL Managed Instance

[!INCLUDE appliesto-sqlmi]

This article teaches you how to configure zone redundancy for 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 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.

Considerations

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

  • Zone redundancy is available in select regions.
  • Zone redundancy isn't 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 Azure SQL hub at aka.ms/azuresqlhub.

  2. In the pane for Azure SQL Managed Instance, select Show options.

  3. In the Azure SQL Managed Instance options window, select Create Azure SQL Managed Instance.

    :::image type="content" source="media/instance-zone-redundancy-configure/show-options-create-sql-managed-instance.png" alt-text="Screenshot from the Azure portal of the Azure SQL hub, showing the Show options button under Azure SQL Managed Instance and the Create Instance pool button." lightbox="media/instance-zone-redundancy-configure/show-options-create-sql-managed-instance.png":::

  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.

    :::image type="content" source="media/instance-zone-redundancy-configure/instance-new-portal-compute-storage.png" alt-text="Screenshot of the backup and zone redundancy options selected on the compute + storage page of the Azure portal." lightbox="media/instance-zone-redundancy-configure/instance-new-portal-compute-storage.png":::

  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 Quickstart: 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 Use PowerShell to create a managed instance.

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 an Azure SQL Managed Instance using 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.

    :::image type="content" source="media/instance-zone-redundancy-configure/instance-existing-portal-compute-storage.png" alt-text="Screenshot of the compute + storage page for an existing instance in the Azure portal. Zone redundancy and backups are selected. " lightbox="media/instance-zone-redundancy-configure/instance-existing-portal-compute-storage.png":::

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 Use PowerShell to create a SQL managed instance.

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 an Azure SQL Managed Instance using 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

Review zone redundancy availability by region for Azure SQL Managed Instance.

Related content