Freigeben über

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

  • Artikel

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.

Comments

  • Anonymous
    January 01, 2003
    If planning to use Azure-only, it may be more effective to use Azure SQL, rather than using VM's within Azure to host SQL - might not fit all scenarios, but it effectively cuts out any maintenance requirements on the VM's (patching, rebooting, etc).