Question : I have created Distributed Availability group set up as below: In Data center A, created 2 node AG1 […]
Tag: distributed-availability-groups
Error in AG Dashboard when looking at a Distributed AG
Question : I have a Distributed AG, but whenever I go to look at the AG Dashboard it says “An […]
Can Availability Group be configured in a below structure?
Question : I have Production and DR clusters as depicted on a picture below. My question is whether there is […]
SQL Server Distributed Availability Group databases not syncing after a Global Primary Replica Failover
Question : SQL Server Distributed Availability Group Environment AG1 => Node1 (AG1-Global Primary) and Node2 (AG1 – Secondary Replica) AG2 […]
Get DAG members
Question : 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 […]
Upgrade with DistributedAG vs adding a node with SQL Server 2019
Question : We would like to migrate from SQL Server 2016 to SQL Server 2019. The databases are part of […]
Distributed Availability Group with Manual Seeding
Question : I am looking for a step by step walk through of how to setup a distributed availability group […]
Distributed Availability Group between SQL Server 2016 and SQL Server 2019 doesn’t seed
Question : Appologies for a long first post 🙂 I’m planning on implementing a distributed availability group between an existing […]
Difference between High Availability data synchronization across local replicas and DAG
Question : I see a significant difference when synchronizing data between Primary – Secondary and between Primary HA and Secondary […]
Failover and Failback SQL server Distributed availability group with different versions
Question : I know that SQL server Distributed availability groups can sync data between two different Major versions, Lets say […]
- 1
- 2