Announcing General Availability (GA) of Zone Redundancy for Azure SQL Database Hyperscale tier
Published Aug 31 2022 10:20 AM 2,067 Views
Microsoft

We are excited to announce the General Availability (GA) of enabling Zone Redundancy for Azure SQL Hyperscale databases. 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 all layers of your Hyperscale databases resilient to a much larger set of failures, including catastrophic datacenter outages, without any changes of the application logic. For more information see Hyperscale zone redundant availability

 

Creating a zone redundant Hyperscale Database

 

A zone redundant Hyperscale database can be created with Portal, Azure CLI, PowerShell, or REST API. Zone redundancy for Hyperscale service tier can only be specified at database creation. This setting cannot be modified once the resource is provisioned. Database copy, point-in-time restore, or creating a geo-replica can be used to update the zone redundant configuration for an existing Hyperscale database.

 

Portal

The following image illustrates how to use Azure portal to configure a new Hyperscale database to be zone redundant. This can be configured in the Configure database blade when creating a new database, creating a geo replica, creating a copy database, doing a point in time restore or doing a geo restore. Zone-redundant or Geo-zone-redundant backup storage and at least 1 High-Availability Secondary Replica must be specified.

 

RajeshSetlem_0-1659597410620.png

 

CLI

The following CLI commands can be used to create a zone redundant Hyperscale database using the –zone-redundant {false, true} parameter.

The Hyperscale database must have at least 1 high availability replica and zone-redundant or geo-zone-redundant backup storage. Below is an example CLI command for creating a new zone redundant Hyperscale database.

 

 

 

 

az sql db create -g mygroup -s myserver -n mydb -e Hyperscale -f Gen5 –ha-replicas 1 –-zone-redundant -–backup-storage-redundancy Zone

 

 

PowerShell

The following PowerShell commands can be used to create a zone redundant Hyperscale database using the -ZoneRedundant parameter.

 

The Hyperscale database must have at least 1 high availability replica and zone-redundant or geo-zone-redundant backup storage must be specified. Below is an example PowerShell command for creating a new zone redundant Hyperscale database.

 

 

 

New-AzSqlDatabase -ResourceGroupName "ResourceGroup01" -ServerName "Server01" -DatabaseName "Database01" -Edition “Hyperscale” -HighAvailabilityReplicaCount 1 -ZoneRedundant -BackupStorageRedundancy Zone

 

 

 

Current Limitations

 

  • Zone redundant configuration can only be specified during database creation. This setting cannot be modified once the resource is provisioned. Database copy, point-in-time restore, or creating a geo-replica can be used to update the zone redundant configuration for an existing Hyperscale database. When using one of these update options, if the target database is in a different region than the source or if the database backup storage redundancy from the target differs from the source database, the copy operation will be a size of data operation.
  • Named replicas are not currently supported.
  • Only Gen5 compute is supported.
  • Zone redundancy cannot currently be specified when migrating an existing database from another Azure SQL Database service tier to Hyperscale. 

Regions where this is available

All Azure regions that have Availability Zones support zone redundant Hyperscale database.

 

Co-Authors
Version history
Last update:
‎Aug 30 2022 12:34 PM
Updated by: