%3CLINGO-SUB%20id%3D%22lingo-sub-1807410%22%20slang%3D%22en-US%22%3EZone%20Redundancy%20for%20Azure%20SQL%20Database%20general%20purpose%20tier%20now%20in%20preview%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1807410%22%20slang%3D%22en-US%22%3E%3CP%3ENow%20in%20preview%2C%20your%20new%20and%20existing%20Azure%20SQL%20Databases%20and%20elastic%20pools%20that%20use%20the%20general%20purpose%20tier%20can%20enable%20the%20zone%20redundant%20configuration.%20The%20zone%20redundant%20configuration%20utilizes%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Favailability-zones%2Faz-overview%23availability-zones%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EAzure%20Availability%20Zones%3C%2FA%3E%20to%20replicate%20databases%20across%20multiple%20physical%20locations%20within%20an%20Azure%20region.%26nbsp%3BBy%20selecting%20zone%20redundancy%2C%20you%20can%20make%20your%20general%E2%80%AFpurpose%20single%20databases%20and%20elastic%20pools%20resilient%20to%20a%20much%20larger%20set%20of%20failures%2C%20including%20catastrophic%20datacenter%20outages%2C%20without%20any%20changes%20of%20the%20application%20logic.%20For%20more%20information%20see%20%3CA%20href%3D%22https%3A%2F%2Faka.ms%2Fdocumentationazuresqlzoneredundancyforgp%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Egeneral%20purpose%20service%20tier%20zone%20redundant%20availability%3C%2FA%3E.%26nbsp%3B%3C%2FP%3E%0A%3CH2%20id%3D%22toc-hId--1215849783%22%20id%3D%22toc-hId--1215849757%22%3E%26nbsp%3B%3C%2FH2%3E%0A%3CH2%20id%3D%22toc-hId-1271663050%22%20id%3D%22toc-hId-1271663076%22%3EHow%20to%20enable%20the%20zone%20redundant%20configuration%3C%2FH2%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20zone%20redundant%20configuration%20can%20be%20enabled%20for%20both%20new%20and%20existing%20general%20purpose%20databases%20and%20elastic%20pools.%20Once%20the%20zone%20redundant%20option%20is%20enabled%2C%20Azure%20SQL%20Database%20will%20automatically%20reconfigure%20the%20database%20or%20pool.%20You%20can%20configure%20this%20setting%20by%20using%20Portal%2C%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fsql-database%2Fsql-database-get-started-cli%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3ECLI%3C%2FA%3E%2C%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fsql-database%2Fsql-database-get-started-powershell%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EPowerShell%3C%2FA%3E%2C%20or%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Frest%2Fapi%2Fsql%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EARM%20API.%3C%2FA%3E%3C%2FP%3E%0A%3CH3%20id%3D%22toc-hId-1962224524%22%20id%3D%22toc-hId-1962224550%22%3E%26nbsp%3B%3C%2FH3%3E%0A%3CH3%20id%3D%22toc-hId-154770061%22%20id%3D%22toc-hId-154770087%22%3EPortal%3C%2FH3%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20following%20diagram%20illustrates%20how%20to%20use%20Azure%20portal%20to%20configure%20a%20general%20purpose%20elastic%20pool%20to%20be%20zone%20redundant.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22zr%20for%20gp%20blog%20post%20picture.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F228427i9499C2A22D61FC34%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22zr%20for%20gp%20blog%20post%20picture.png%22%20alt%3D%22zr%20for%20gp%20blog%20post%20picture.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH3%20id%3D%22toc-hId--1652684402%22%20id%3D%22toc-hId--1652684376%22%3E%26nbsp%3B%3C%2FH3%3E%0A%3CH3%20id%3D%22toc-hId-834828431%22%20id%3D%22toc-hId-834828457%22%3ECLI%3C%2FH3%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20following%20CLI%20commands%20can%20be%20used%20to%20enable%20the%20zone%20redundant%20configuration%20using%20the%20%E2%80%93zone-redundant%20%7Bfalse%2C%20true%7D%20parameter.%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3E%3CU%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fcli%2Fazure%2Fsql%2Fdb%3Fview%3Dazure-cli-latest%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Eaz%3C%2FA%3E%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fcli%2Fazure%2Fsql%2Fdb%3Fview%3Dazure-cli-latest%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Esql%3C%2FA%3E%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fcli%2Fazure%2Fsql%2Fdb%3Fview%3Dazure-cli-latest%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Edb%3C%2FA%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fcli%2Fazure%2Fsql%2Fdb%3Fview%3Dazure-cli-latest%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%20create%3C%2FA%3E%3C%2FU%3E%3C%2FLI%3E%0A%3CLI%3E%3CU%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fcli%2Fazure%2Fsql%2Felastic-pool%3Fview%3Dazure-cli-latest%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Eaz%3C%2FA%3E%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fcli%2Fazure%2Fsql%2Felastic-pool%3Fview%3Dazure-cli-latest%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Esql%3C%2FA%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fcli%2Fazure%2Fsql%2Felastic-pool%3Fview%3Dazure-cli-latest%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%20elastic-pool%20create%3C%2FA%3E%3C%2FU%3E%3C%2FLI%3E%0A%3CLI%3E%3CU%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fcli%2Fazure%2Fsql%2Fdb%3Fview%3Dazure-cli-latest%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ea%3C%2FA%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fcli%2Fazure%2Fsql%2Fdb%3Fview%3Dazure-cli-latest%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ez%3C%2FA%3E%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fcli%2Fazure%2Fsql%2Fdb%3Fview%3Dazure-cli-latest%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Esql%3C%2FA%3E%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fcli%2Fazure%2Fsql%2Fdb%3Fview%3Dazure-cli-latest%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Edb%3C%2FA%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fcli%2Fazure%2Fsql%2Fdb%3Fview%3Dazure-cli-latest%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%20update%3C%2FA%3E%3C%2FU%3E%3C%2FLI%3E%0A%3CLI%3E%3CU%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fcli%2Fazure%2Fsql%2Felastic-pool%3Fview%3Dazure-cli-latest%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Eaz%3C%2FA%3E%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fcli%2Fazure%2Fsql%2Felastic-pool%3Fview%3Dazure-cli-latest%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Esql%3C%2FA%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fcli%2Fazure%2Fsql%2Felastic-pool%3Fview%3Dazure-cli-latest%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%20elastic-pool%20update%3C%2FA%3E%3C%2FU%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CH3%20class%3D%22lia-align-left%22%20id%3D%22toc-hId--972626032%22%20id%3D%22toc-hId--972626006%22%3E%26nbsp%3B%3C%2FH3%3E%0A%3CH3%20id%3D%22toc-hId-1514886801%22%20id%3D%22toc-hId-1514886827%22%3EPowerShell%3C%2FH3%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20following%20PowerShell%20commands%20can%20be%20used%20to%20enable%20the%20zone%20redundant%20configuration%20using%20the%20-ZoneRedundant%20parameter.%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%20class%3D%22lia-align-left%22%3E%3CU%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpowershell%2Fmodule%2Faz.sql%2Fnew-azsqldatabase%3Fview%3Dazps-3.8.0%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3ENew-%3C%2FA%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpowershell%2Fmodule%2Faz.sql%2Fnew-azsqldatabase%3Fview%3Dazps-3.8.0%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EAzSqlDatabase%3C%2FA%3E%3C%2FU%3E%3C%2FLI%3E%0A%3CLI%20class%3D%22lia-align-left%22%3E%3CU%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpowershell%2Fmodule%2Faz.sql%2Fnew-azsqlelasticpool%3Fview%3Dazps-3.6.1%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3ENew-%3C%2FA%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpowershell%2Fmodule%2Faz.sql%2Fnew-azsqlelasticpool%3Fview%3Dazps-3.6.1%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EAzSqlElasticPool%3C%2FA%3E%3C%2FU%3E%3C%2FLI%3E%0A%3CLI%20class%3D%22lia-align-left%22%3E%3CU%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpowershell%2Fmodule%2Faz.sql%2Fset-azsqldatabase%3Fview%3Dazps-3.8.0%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3ESet-%3C%2FA%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpowershell%2Fmodule%2Faz.sql%2Fset-azsqldatabase%3Fview%3Dazps-3.8.0%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EAzSqlDatabase%3C%2FA%3E%3C%2FU%3E%3C%2FLI%3E%0A%3CLI%20class%3D%22lia-align-left%22%3E%3CU%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpowershell%2Fmodule%2Faz.sql%2Fset-azsqlelasticpool%3Fview%3Dazps-3.6.1%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3ESet-%3C%2FA%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpowershell%2Fmodule%2Faz.sql%2Fset-azsqlelasticpool%3Fview%3Dazps-3.6.1%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EAzSqlElasticPool%3C%2FA%3E%3C%2FU%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CH3%20id%3D%22toc-hId--292567662%22%20id%3D%22toc-hId--292567636%22%3E%26nbsp%3B%3C%2FH3%3E%0A%3CH3%20id%3D%22toc-hId--2100022125%22%20id%3D%22toc-hId--2100022099%22%3EARM%3C%2FH3%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20zone%20redundant%20configuration%20can%20be%20enabled%20using%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Frest%2Fapi%2Fsql%2FDatabases%2FCreateOrUpdate%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ecreate%20or%20update%20in%20ARM.%3C%2FA%3E%3C%2FP%3E%0A%3CH2%20id%3D%22toc-hId--436755490%22%20id%3D%22toc-hId--436755464%22%3E%26nbsp%3B%3C%2FH2%3E%0A%3CH2%20id%3D%22toc-hId-2050757343%22%20id%3D%22toc-hId-2050757369%22%3ERegions%20where%20this%20is%20available%3C%2FH2%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EZone%20redundant%20general%20purpose%20Azure%20SQL%20databases%20and%20pools%20are%20available%20in%20preview%20in%20the%20following%20regions%3A%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3E%3CSTRONG%3EEast%20US%3C%2FSTRONG%3E%3C%2FLI%3E%0A%3CLI%3E%3CSTRONG%3EEast%20US%202%3C%2FSTRONG%3E%3C%2FLI%3E%0A%3CLI%3E%3CSTRONG%3EWest%20US%202%3C%2FSTRONG%3E%3C%2FLI%3E%0A%3CLI%3E%3CSTRONG%3ENorth%20Europe%3C%2FSTRONG%3E%3C%2FLI%3E%0A%3CLI%3E%3CSTRONG%3EWest%20Europe%3C%2FSTRONG%3E%3C%2FLI%3E%0A%3CLI%3E%3CSTRONG%3ESoutheast%20Asia%3C%2FSTRONG%3E%3C%2FLI%3E%0A%3CLI%3E%3CSTRONG%3EAustralia%20East%3C%2FSTRONG%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3EAdditional%20regions%20will%20be%20added%20over%20time.%20Visit%20the%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Favailability-zones%2Faz-region%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Edocumentation%3C%2FA%3E%20for%20up%20to%20date%20information%20on%20regions%20that%20support%20Availability%20Zones%20in%20Azure.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPlease%20visit%20the%20pricing%20pages%20for%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fazure.microsoft.com%2Fpricing%2Fdetails%2Fsql-database%2Fsingle%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Esingle%20databases%3C%2FA%3E%26nbsp%3Band%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fazure.microsoft.com%2Fpricing%2Fdetails%2Fsql-database%2Felastic%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Eelastic%20pools%3C%2FA%3E%26nbsp%3Bfor%26nbsp%3Bpricing%20details%20for%20this%20configuration.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-1807410%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20zone%20redundant%20configuration%20for%20Azure%20SQL%20Database%20general%20purpose%20tier%20is%20now%20in%20preview%20-%20learn%20more!%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1807410%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%20SQL%20Database%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Microsoft

Now in preview, your new and existing Azure SQL Databases and elastic pools that use the general purpose tier can enable the zone redundant configuration. 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 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. 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 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 diagram illustrates how to use Azure portal to configure a general purpose elastic pool to be zone redundant.

 

zr for gp blog post picture.png

 

 

CLI

 

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

 

PowerShell

 

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

 

ARM

 

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

 

Regions where this is available

 

Zone redundant general purpose Azure SQL databases and pools are available in preview in the following regions:

  • East US
  • East US 2
  • West US 2
  • North Europe
  • West Europe
  • Southeast Asia
  • Australia East

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.