Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [distributed-availability-groups]

A variation of the existing AOAG feature that connect AGs in two or more clusters. Distributed Availability Groups are a new feature in SQL Server 2016.

0
votes
1answer
52 views

Get DAG members

Via transact SQL with this query: SELECT ag.[name] as 'AG Name', ag.Is_Distributed, ar.replica_server_name as 'Replica Name' FROM sys.availability_groups ag, sys....
0
votes
1answer
27 views

Orphaned Availability Group Name

So I was creating a distributed availability group and noticed I wanted to change the name of the AG so I tried to run DROP AVAILABILITY GROUP. But it was already seeding and was just stuck in "...
1
vote
0answers
141 views

Configuring Availability group between Two SQL Server Failover Cluster Instances

I am having two Windows clusters. Two SQL cluster instances are there in each two node cluster ( Data centre 1 :Windows Cluster 1-SQL2016CLUS1 Node 1 Node 2 SQL 2016 failover cluster instance1 -...
1
vote
0answers
326 views

Distributed Availability Group Failover Issue

I have created Distributed Availability group set up as below: In Data center A, created 2 node AG1 setup (Synchronous) in Datacenter B, created 2 node AG2 setup (asynchronous). Created Distributed ...