Azure_SQLServers_16 - Cloudlytics

Azure_SQLServers_16

Ensure Azure SQL Server data replication with Fail Over group

Description

SQL Server data should be replicated to avoid loss of unreplicated data.

Remediation

Perform the following in the Azure Console:

Go to SQL Servers
For each SQL Server
Select Failover groups
Press the Add group link on top of the page

Perform the following in Azure Command Line Interface 2.0:

sql failover-group create –name <failoverGroupName> -g <ResourceGroupName> -s <SQLServerName> –partner-server <PartnerSesrver>

Service

Database Services

Severity

Medium

Compliance

Mapping