Share via

extend Azure SQL always on availability group to on prem

Abdalrahman Allahham 40 Reputation points
2024-04-15T13:47:40.6133333+00:00

I have an Azure SQL always on availability group with 2 servers, i need to add another on-prem node to the AG.

Azure SQL AG deployed in a single subnet with DNN listener, and i already have S2S connectivity between Azure and on-prem.

do i have to migrate the SQL AG to a multi-subnet configuration, or the new node will be added without any extra configuration?

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,852 questions
0 comments
Accepted answer
  1. Satya Prakash 80 Reputation points
    2024-04-15T18:33:21.0866667+00:00

    You can add the on-premises node to your existing Azure SQL AlwaysOn Availability Group with a DNN listener in a single subnet. No need to migrate to multi-subnet.

    Use SSMS on an existing Azure SQL server in the AG, run the "Add Replica" wizard, choose "Deploy a new replica on a Windows Server Failover Cluster" and provide your on-premises server details. The wizard will handle the DNN listener automatically.

    1 person found this answer helpful.
    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest