Skip to content

Latest commit

 

History

History
173 lines (109 loc) · 11 KB

instance-zone-redundancy-configure.md

File metadata and controls

173 lines (109 loc) · 11 KB
title description author ms.author ms.reviewer ms.date ms.service ms.subservice ms.topic
Configure zone redundancy
Configure zone redundancy for your Azure SQL Managed Instance by using the Azure portal, PowerShell, Azure CLI, and REST API.
Stralle
strrodic
urmilano, mathoma, randolphwest
09/22/2024
azure-sql-managed-instance
high-availability
conceptual

Configure zone redundancy - Azure SQL Managed Instance

[!INCLUDE appliesto-sqlmi]

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.

    :::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 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.

    :::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 with zone redundancy and backups 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 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 is supported in the following regions:

Note

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

| Americas | Europe | Middle East and Africa | Asia Pacific | | --- | --- | --- | --- | --- | | Brazil South | France Central | Israel Central | Australia East | | Canada Central | Germany West Central | Qatar Central | Central India | | Central US | Italy North | South Africa North | East Asia | | East US | North Europe | UAE North | Japan East | | East US 2 | Norway East | | Japan West | | Mexico Central | Poland Central | | Korea Central | | West Central US | Spain Central | | New Zealand North | | West US 2 | Sweden Central | | Southeast Asia | | West US 3 | Switzerland North | | | | | UK South | | | | | West Europe | | |

Related content

To learn more, review: