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
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 ...
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 ...
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..
...
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 ...
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 ...
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 ...
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 ...
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 ...
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). ...
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 ...
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.
...