A financial services company hosts a transactional SQL Server database on an Azure virtual machine (VM) in the East US region. You are designing a disaster recovery (DR) solution to the West US region. The solution must meet a Recovery Time Objective (RTO) of and a Recovery Point Objective (RPO) of .
The database VM has the following storage configuration:
- One OS disk
- One Premium SSD disk for transaction logs, with a peak write churn of
- Two Premium SSD disks for database files, with a combined peak write churn of
Which disaster recovery solution should you recommend?
- Configure SQL Server Always On Availability Groups to replicate the database to a target virtual machine in the West US region.Cevap
- BEnable Azure Site Recovery (ASR) replication for the virtual machine and configure the High Churn replication policy.
- CConfigure Azure Backup with Cross-Region Restore (CRR) to replicate the virtual machine's daily backups to the West US region.
- DEnable Azure Site Recovery (ASR) replication for the virtual machine and deploy an on-premises configuration server to manage replication.
Cevap
Configure SQL Server Always On Availability Groups to replicate the database to a target virtual machine in the West US region.
The transaction log disk has a peak write churn of , and the total peak write churn of the virtual machine is . Azure Site Recovery (ASR) has a maximum supported write churn limit of per disk and per virtual machine, even when using the High Churn policy. Since these limits are exceeded, ASR cannot be used. Implementing database-level replication such as SQL Server Always On Availability Groups is the correct design pattern because it operates at the database engine layer and is not bound by ASR's disk-level write churn replication limits.
Adım Adım Çözüm
Anahtar Kavram
Azure Site Recovery write churn limits and database-level replication alternatives
Tahmini Süre:1m 30s