(SQL) Tip of the Day: High Availability and Disaster Recovery for SQL Server in Azure Virtual Machines

Today’s (SQL) Tip…

“Microsoft Azure virtual machines (VMs) with SQL Server can help lower the cost of a high availability and disaster recovery (HADR) database solution. Most SQL Server HADR solutions are supported in Azure virtual machines, both as Azure-only and as hybrid solutions. In an Azure-only solution, the entire HADR system runs in Azure. In a hybrid configuration, part of the solution runs in Azure and the other part runs on-premises in your organization. The flexibility of the Azure environment enables you to move partially or completely to Azure to satisfy the budget and HADR requirements of your SQL Server database systems.” -- https://msdn.microsoft.com/en-us/library/jj870962.aspx

I would like to point out the most interesting concept (to me) is the hybrid model. You could then have multiple secondary servers either in the cloud or on premise used for reported and disaster recovery.