Share via

SQL Server in Azure VM High Availability and Disaster Recovery

  • Article

This is the most commonly asked question on SQL Server in Azure Virtual Machine. How to maintain SQL Server up and running all the time. Options are

High Availability (Azure)

1. AlwaysOn Availability Groups (https://msdn.microsoft.com/en-us/library/azure/dn249504.aspx)

2. Database Mirroring (https://msdn.microsoft.com/en-us/library/azure/jj870961.aspx)

Disaster Recovery (Azure)

1. AlwaysOn Availability Groups (https://msdn.microsoft.com/en-us/library/azure/dn690122.aspx)

2. Database Mirroring (https://msdn.microsoft.com/en-us/library/azure/jj870960.aspx)

3. Backup and Restore with Azure Blob Storage Service (https://msdn.microsoft.com/en-us/library/azure/dn133143.aspx)

Hybrid IT : Disaster Recovery

In this case we can use our on-premises SQL Server and have the HADR setup. Now to do that you have some options as well available.

1. AlwaysOn Availability Groups

2. Database Mirroring (https://msdn.microsoft.com/en-us/library/azure/jj870964.aspx)

3. Log Shipping (https://msdn.microsoft.com/en-us/library/azure/jj889442.aspx)

4. Backup and Restore with Azure Blob Storage Service (https://msdn.microsoft.com/en-us/library/azure/dn133143.aspx )

Consideration for Azure HADR

It is important to understand some important things of Azure. You need to keep the VMs in Availability Set. To keep the VMs in Availability Set you must keep them in same Cloud Service.

Also it is mandatory that one should know How to Configure Windows Failover Cluster in Azure for AlwaysOn Availability Groups

Namoskar!!!