A media streaming company hosting its application in the Azure North Europe region wants to design a disaster recovery (DR) solution to the West Europe region. The application runs on two Azure virtual machines (VMs):
- `vm-web`: A web server VM with one Standard SSD disk that has a write churn rate of .
- `vm-db`: A SQL Server database VM with two Premium SSD disks: a data disk with a write churn rate of and a log disk with a write churn rate of .
The disaster recovery solution must achieve a Recovery Point Objective (RPO) of 2 hours and a Recovery Time Objective (RTO) of 4 hours.
Which disaster recovery configuration should you recommend to meet these requirements?
- Replicate `vm-web` using Azure Site Recovery, and configure SQL Server Always On Availability Groups to replicate the databases on `vm-db` to the West Europe region.Answer
- BReplicate both `vm-web` and `vm-db` to the West Europe region using Azure Site Recovery with enhanced replication and high-churn support enabled.
- CReplicate both `vm-web` and `vm-db` to the West Europe region using Azure Site Recovery with standard replication.
- DConfigure Read-Access Geo-Redundant Storage (RA-GRS) for the managed disks of both `vm-web` and `vm-db` to enable geo-replication, and boot the VMs in West Europe during a failover.
Answer
Replicate `vm-web` using Azure Site Recovery, and configure SQL Server Always On Availability Groups to replicate the databases on `vm-db` to the West Europe region.
The correct configuration is to replicate the web server VM using Azure Site Recovery and to configure SQL Server Always On Availability Groups to replicate the database. This is because the database log disk write churn of exceeds the maximum supported write churn limit of per Premium SSD disk for Azure Site Recovery (even with enhanced high-churn support). Therefore, native SQL Server replication must be utilized for the database tier, while the web tier can be safely replicated using ASR since its disk churn of is well within limits.
Step-by-Step Solution
Key Concept
Azure Site Recovery limits require separating high-churn database workloads to native replication tools like SQL Server Always On Availability Groups when disk write churn exceeds supported limits.