SQL Database should enable zone redundancy

Medium Azure General databases-sql-database-enable-zone

Applies to

Microsoft.Sql/servers/databases

What CGPulse checks

A resource passes this rule when zoneRedundant must equal true. Anything else is reported as a finding with the evaluated property value attached as evidence.

How to fix it

Configure zone-redundant high availability to protect against zone failures. In Azure Portal: SQL Database > Compute + storage > enable Zone redundancy. See: https://learn.microsoft.com/en-us/azure/azure-sql/database/high-availability-sla

CLI

az sql db update --ids "{id}" --zone-redundant true

Bicep

resource database 'Microsoft.Sql/servers/databases@2023-08-01-preview' = {
  name: '<database-name>'
  parent: sqlServer
  location: location
  properties: {
    zoneRedundant: true
  }
  sku: { name: 'P1', tier: 'Premium' }
}

Terraform

resource "azurerm_mssql_database" "{name}" {
  name           = "<database-name>"
  server_id      = azurerm_mssql_server.{name}.id
  zone_redundant = true
  sku_name       = "P1"
}

Compliance frameworks

Cloud Security: Azure Foundations

Is your environment compliant with this rule?

CGPulse checks it — and 621 others — against your Azure and AWS accounts with read-only access.

Run a free scan