Page Comparison

Severity : High

Description: Creating SQL Database instances in a single availability zone creates a single point of failure for all systems relying on that database. All SQL Database instances should be created in multiple availability zones to ensure proper failover. Remediation Steps : Ensure that each SQL Database is configured to be zone redundant.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