CODEWITHSUNDEEP
azureazure-sql-databaseazure-storage
Gaurav
Gaurav

Reputation: 915

Disaster Recovery for azure virtual machines using geo-replicated storage

We are using Azure Virtual machines to host our application in the cloud. Couple of virtual machines are hosting web front-end(state-less) and one virtual machine is hosting SQL Server (data is stored in Data Disk).

As we all know, these virtual machines consist of OS Disk and Data Disk(optional) which uses VHD files stored in blob storage. We are using geo-redundant blob storage which stores these VHD files.

We are now planning for disaster recovery for our cloud application. So if a Microsoft data center is down, is it possible to spin up virtual machines in another data center with the help of OS Disk and Data Disk stored in geo-replicated storage?

Upvotes: 1

Views: 4091

Answers (2)

Greg Faulk
Greg Faulk

Reputation: 21

You are not supposed to use geo-replicated storage with SQL Server data disks. This is documented at https://msdn.microsoft.com/library/azure/dn133149.aspx. Specifically, the document states "When creating a storage account, disable geo-replication as consistent write order across multiple disks is not guaranteed. Instead, consider configuring a SQL Server disaster recovery technology between two Azure data centers".

Upvotes: 2

mcollier
mcollier

Reputation: 3719

Currently you can not control if/when Microsoft fails over to the secondary (geo-replicated) storage account. Microsoft controls that.

As I understand it, in the event that Microsoft does declare a disaster and fails over, then your VMs would still work. Perhaps you'd have to create the VM again from the VHD, but the data would be there (minus anything lost since the last sync to storage).

Upvotes: 0

Related Questions