Share via

On Premises and Azure SQL VM Always On Availability Groups

Nitin Arora 25 Reputation points
2024-01-01T07:10:11.21+00:00

I am wondering if it is possible to create a SQL Always On Availability Group with on-premises servers and SQL Azure VMs. Please validate two scenarios below.

SQL Always on

SQL Always on 2

Azure SQL Database
Azure Arc
Azure Arc
A Microsoft cloud service that enables deployment of Azure services across hybrid and multicloud environments.
341 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Luca Lionetti 3,131 Reputation points
    2024-01-02T18:21:40.0066667+00:00

    Hi,

    Welcome to Microsoft Q&A community forum!

    You can extend on-premises Availability Groups to Microsoft Azure by provisioning one or more Azure VMs with SQL Server and then adding them as replicas to your on-premises Availability Groups.

    Because all availability replicas must be in the same WSFC cluster, the WSFC cluster must span both networks (a multi-subnet WSFC cluster). This configuration requires a VPN connection between Azure and the on-premises network.

    Screenshot 2024-01-02 192010

    Take a look at this ref links

    https://github.com/Huachao/azure-content/blob/master/articles/virtual-machines/virtual-machines-sql-server-extend-on-premises-alwayson-availability-groups.md

    Hope this helps

    Cheers

    Luca

    Please "Accept as Answer" and Upvote if the answer provided is useful, so that you can help others in the community looking for remediation for similar issues

  2. Oury Ba-MSFT 16,901 Reputation points Microsoft Employee
    2024-01-03T20:43:31.7166667+00:00

    @Nitin Arora

    Thank you for reaching out.

    My understanding is that you are looking to create a SQL Always On Availability Group with On-Premises server and SQL Azure VMs.

    If that is the case, then yes, it is possible to create a SQL Always On Availability Group with on-premises servers and SQL Azure VMs. According to Microsoft, Always On availability groups on Azure Virtual Machines are similar to Always On availability groups on-premises and rely on the underlying Windows Server Failover Cluster.

    For the 2 scenarios illustrated above.

    If the VMs are in the same Azure region the availability group replicas can have synchronous commit with automatic failover for both instances.

    When availability group replicas are on Azure virtual machines in different Azure regions, you can connect the virtual networks by using virtual network peering or a site-to-site VPN gateway.

    This documentation has detailed information and example Configure an availability group across Azure regions - SQL Server on Azure VMs

    Regards,

    Oury