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.

11 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
2 votes
0 answers
253 views

Problems with Distributed Availability Group( DAG)

I have 2 servers in AWS Central joined with AWSCentralAG and I have 2 servers in AWS West joined with AWSWestAG. Obviously, I have the listener name and listener IP address and I able to connect to ...
Sid 's user avatar
  • 175
2 votes
0 answers
512 views

Distributed Availability Group Endpoint_URL Setup Question

I have two sites: SiteA and SiteB. Both sites are running SQL Server 2017 Enterprise v14.0.3048.4 on Windows 2012. Both sites are linked with a dedicated VPN connection. We have a series of ...
Alf47's user avatar
  • 961
1 vote
1 answer
235 views

Sync logins and Agent jobs across all replicas in Distributed Availability Group

I am using dba_CopyLogins stored proc to sync logins on replicas in Distributed Availability groups, but the database level permissions are not transferred due to database sync operation is going on.. ...
kpx's user avatar
  • 11
0 votes
0 answers
58 views

Why Bytes Sent to Transport/sec is different on different replicas?

I am troubleshooting latency for a specific replica in a Distributed AG setup (with 2 remote replicas). Looking at perfmon I see clear indication as to why one replica shows delay. I see Bytes Sent to ...
GAURAV RATHOD's user avatar
0 votes
0 answers
153 views

When I connected SQL Server 2019 Management Studio Connection to Integration Services it shows me Error Class Not Registered

I'm installed SQL Server 2019 Enteprisse in the first server and I have other server with SQL Server 2019 Standar Edition ,both server when I tried connect with the Integration Service SQL server 2019 ...
Kalusql's user avatar
0 votes
0 answers
110 views

How to activate MSDTC for SQL Server 2019 failover cluster

I have configured a failover cluster and always on SQL Server 2019 high availability group on 2 nodes and operating system with Windows Server 2019. I am trying to configure the MSDTC properties of ...
Kalusql's user avatar
0 votes
1 answer
17 views

Can I distribute a distributed availability group?

Server1 and Server2 make up a NEW availability group: AGServer. DMZ1 and DMZ2 already make up an existing availability group: AGDMZ. Currently DMZ1 & DMZ2 are part of a Distributed Availability ...
CrushingIT's user avatar
0 votes
2 answers
652 views

Backup on Distributed AG setup

I have setup a distibruted availability group and trying to understand behaviour of backups on it. While I can take backup from primary replica of Primary AG, I can not take backup from primary ...
GAURAV RATHOD's user avatar
0 votes
0 answers
48 views

Failing Over on the Fisrt SQL Server AG at one Location breaks the Distributed AG at the Second Location

I have configured a SQL Server Distributed Availability Group (AG), containing a Windows cluster with an AG at one location, and a second cluster with its own AG at another location (thus, two AGs). ...
JF0001's user avatar
  • 163
0 votes
1 answer
107 views

SQL Server Distributed Availability Group Usage Pattern

I have got a client with DAG setup on 2016 & 2017 servers. I understand that their usage is most likely for DR purposes. What I'm a little unclear on (and I can't find any info on it) is how they ...
user30724's user avatar
0 votes
1 answer
88 views

Adding ReadOnly Domain-less replica to existing AG with two replicas on two nodes WSFC

I have AG setup as follows: Multi sub-net WSFC (Windows Server 2016) - All nodes part of same domain AG with two replicas (SQL 2017) - Each node (mentioned above) contains one standalone instance. ...
ymsalem's user avatar