Always On HA+DR

Vishu 1,596 Reputation points
2020-07-20T08:11:06.927+00:00

Hi Experts,

I was trying to setup a alwayson between onpremise datacenter and azure(1 node in datacenter and 1 in azure) with an average latency of 125 MS.
Any feedback if anyone has done a similar setup and if any issues to it.

Thanks

SQL Server on Azure Virtual Machines
{count} votes

1 answer

Sort by: Most helpful
  1. KarishmaTiwari-MSFT 20,127 Reputation points Microsoft Employee
    2020-08-06T23:31:57.543+00:00

    Apologies for the delay in response. I might need additional information to help you out on your issue.

    Is your question about SQL Server on Azure VM, and if so, can you please share details on what networking and other IaaS components are part of the solution?
    If this is Azure SQL Database (PaaS), are you using Data Replication or Data Sync?

    Azure SQL Database (PaaS) Always On Availability Groups does not support 'Always On' with an On-Premise instance.
    However, 'SQL Server on a VM' support Active Directory domain-independent clusters.

    Please refer to:
    Configure a workgroup availability group where IaaS can better support the on-premise networking aspect.
    Tutorial: Configure a SQL Server availability group on Azure Virtual Machines manually

    Azure SQL Database (PaaS) 'Always On' Availability Groups is primarily supported by Azure Paired Regions and the high bandwidth networking between these paired regions to fail-over sets of databases at a time.

    Here is a reference document for Azure PaaS Database services: High availability for Azure SQL Database and SQL Managed Instance.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.