Arc Enabled Data Services – 12

Azure Arc-enabled SQL MI Disaster Recovery

Views 1231

In the previous post, we introduced you to how Azure Arc-enabled SQL MI provides High Availability based on the tier you have deployed.  If your environment requires disaster recovery, regardless of the tier level you have deployed, Azure Arc-enabled Data Services covers the job for you.

You will require to build your secondary site and have a secondary Kubernetes cluster and deploy the required Arc-enabled SQL MI instances to match your primary site. You will need to ensure that both sites (primary and secondary) are created with the same resources.

Once you have both sites configured, you are able to link these up, providing you with your disaster recovery by creating the appropriate Azure Failover Group.

Azure Failover groups utilize the contained Availability Group functionality to replicate from your primary to your secondary site providing you with the coverage that you require.

In our next post we will have a look at monitoring your Azure Arc-enabled SQL MI environment.

Leave a Reply

Your email address will not be published. Required fields are marked *


I am a Microsoft Data Platform MVP as well as a Microsoft Certified Master working as the Principal Consultant here at SQL Masters Consulting. When I am not working with the SQL Server Stack I like to get away to the Snow and spend time Snowboarding.