Zone redundancy for Azure SQL Database general purpose tier
Published Apr 13 2022 09:00 AM 24.2K Views
Microsoft

Update: 
October - December 2022: General Availability of zone redundancy for General Purpose tier expanded to East US2, East US & Southeast Asia regions. 

January 2023: General Availability of zone redundancy for General Purpose tier expanded to Qatar Central region. 
May 2023: General Availability of zone redundancy for General Purpose tier expanded to Australia East, Brazil South, South Central US & UK South regions. 

June 2023: General Availability of zone redundancy for General Purpose tier expanded to Japan East & Korea Central regions. 

July 2023: General Availability of zone redundancy for General Purpose tier expanded to East Asia region. 

September 2023: General Availability of zone redundancy for General Purpose tier expanded to Switzerland North, Sweden Central, South Africa North, Central India & China North 3 region.

October 2023: General Availability of zone redundancy for General Purpose tier expanded to UAE North & Norway East regions.

December 2023: General Availability of zone redundancy for General Purpose tier expanded to Italy North, Poland Central, Israel Central, West US 3 & Germany West Central

February 2024: General Availability of zone redundancy for General Purpose tier expanded to Canada Central.

 

Now generally available in select regions, your new and existing Azure SQL Databases and elastic pools that use the general purpose tier can enable the zone redundant configuration. This configuration is offered for both serverless and provisioned compute.

 

The zone redundant configuration utilizes Azure Availability Zones to replicate databases across multiple physical locations within an Azure region. By selecting zone redundancy, you can make your serverless and provisioned general purpose single databases and elastic pools resilient to a much larger set of failures, including catastrophic datacenter outages, without any changes of the application logic. This configuration offers 99.995% availability SLA and RPO=0. For more information see general purpose service tier zone redundant availability

 

 

How to enable the zone redundant configuration

 

The zone redundant configuration can be enabled for both new and existing serverless and provisioned general purpose databases and elastic pools. Once the zone redundant option is enabled, Azure SQL Database will automatically reconfigure the database or pool. You can configure this setting by using Portal, CLIPowerShell, or ARM API.

 

Portal

 

The following diagrams illustrate how to use Azure portal to configure a new general purpose provisioned database to be zone redundant.

 

Step 1: Select Configure database in the Create SQL Database blade.

Emily_Lisa_0-1649447283950.png

 

Step 2: In the Configure blade select Yes to make the database zone redundant then click Apply.

Emily_Lisa_1-1649447566133.png

 

 

CLI

 

The following CLI commands can be used to enable the zone redundant configuration using the –zone-redundant {false, true} parameter.

Below is an example CLI command for creating a new zone redundant provisioned general purpose tier Azure SQL database.

 

 

 

 

 

 

az sql db create -g mygroup -s myserver -n mydb -e GeneralPurpose --zone-redundant

 

 

 

 

 

PowerShell

 

The following PowerShell commands can be used to enable the zone redundant configuration using the -ZoneRedundant parameter.

Below is an example PowerShell command for creating a new zone redundant provisioned general purpose tier Azure SQL database.

 

 

 

 

 

 

New-AzSqlDatabase -ResourceGroupName "ResourceGroup01" -ServerName "Server01" -DatabaseName "Database03" -Edition "GeneralPurpose" -ZoneRedundant

 

 

 

 

 

 

ARM

The zone redundant configuration can be enabled using create or update in ARM.

 

Regions where this is available

 

Zone redundant Azure SQL database general purpose tier is generally available in the following regions:

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

Note:
General availability expanded to East US 2, East US & Southeast Asia regions during Oct-Dec 2022. 

General availability expanded to Qatar Central region in January 2023. 

General availability expanded to Australia East, Brazil South, South Central US& UK South regions in May 2023. 

General availability expanded to Japan East & Korea Central regions in June 2023. 

General availability expanded to East Asia region in July 2023. 

General Availability of zone redundancy for General Purpose tier expanded to Switzerland North, Sweden Central, South Africa North, Central India & China North 3 regions in September 2023.

General Availability of zone redundancy for General Purpose tier expanded to UAE North & Norway East regions in October 2023.

General Availability of zone redundancy for General Purpose tier expanded to Italy North, Poland Central, Israel Central, West US 3 & Germany West Central in December 2023.

General Availability of zone redundancy for General Purpose tier expanded to Canada Central in February 2024.

 

 

Additional regions will be added over time. Visit the documentation for up-to-date information on regions that support Availability Zones in Azure.

 

Please visit the pricing pages for single databases and elastic pools for pricing details for this configuration.

 

 

 

3 Comments
Co-Authors
Version history
Last update:
‎Feb 09 2024 01:56 PM
Updated by: