Azure-SQLDatabases-SQL-DB-Multiple-AZ

Severity : High

Description: This control ensures that SQL database application uses the multiple availability zone to guarantee the database up time and application continuity in the event of service outage in a zone. Azure Availability Zones tries to protect against the outage of a single datacenter building within a single region. It helps you protect against the loss of power or network to a building. In SQL Database, you place the different replicas in different availability zones. With high availability across availability zone provides an automatic backups, point-in time restore and active geo-replication.

Remediation Steps:

Perform following to enable zone redundancy for SQL DB :

1. Login to Azure Portal using https://portal.azure.com.

2. Navigate to SQL Database.

3. Select the SQL database resource from the list of the database.

4. Under Settings, Select Configure.

5. In the tier specific tab for Standard or Premium service tab, select Yes for question Would you like to make this database zone redundant?

6. Click on Apply button.

Important:

Reference:

• https://azure.microsoft.com/en-us/blog/azure-sql-database-now-offers-zone-redundant-premium-databases-and-elastic-pools/

• https://techcommunity.microsoft.com/t5/azure-sql-blog/zone-redundancy-for-azure-sql-database-serverless-and-general/ba-p/1807410