SQL Database should use geo-redundant backup storage

Medium Azure General databases-backup

Applies to

Microsoft.Sql/servers/databases

What CGPulse checks

A resource passes this rule when requestedBackupStorageRedundancy must be one of ["Geo","GeoZone"]. Anything else is reported as a finding with the evaluated property value attached as evidence.

How to fix it

Enable geo-redundant backup to protect against regional outages causing data loss. In Azure Portal: SQL Database > Backups > configure Backup storage redundancy to Geo. See: https://learn.microsoft.com/en-us/azure/azure-sql/database/automated-backups-overview

CLI

az sql db update --ids "{id}" --backup-storage-redundancy Geo

Bicep

resource database 'Microsoft.Sql/servers/databases@2023-08-01-preview' = {
  name: '<database-name>'
  parent: sqlServer
  location: location
  properties: {
    requestedBackupStorageRedundancy: 'Geo'
  }
}

Terraform

resource "azurerm_mssql_database" "{name}" {
  name                        = "<database-name>"
  server_id                   = azurerm_mssql_server.{name}.id
  geo_backup_enabled          = true
  storage_account_type        = "Geo"
}

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