Forum Discussion
Using Azure as an HA/DR site for SQL 2016
I wonder if anyone has dabbled with this concept, or if it is economically viable to my customer, which is a "little big shop" that would like to spend $-- for SQL HA and/or DR (probably the latter i...
Good day,
As you can see in the book online (under the title "THIS TOPIC APPLIES TO") Always On Availability Groups does not supported in Azure SQL Databaseno or Azure SQL Data Warehouse (yet), but you can still use Azure for your Disaster Recovery (DR).
For example, you can configure Always On availability group in Azure VM
In addition you can use replication from local SQL to SQL Server Azure if you want, which is bery useful for lot of cases. For more information check this article
* Of course I cannot advise you, since I am not familiar with your system