cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 8

SQL 2016 Distributed Availability Groups

Please share your inputs if you have experienced with this kind of scenario.

I have 3 AG group.

1. Primary Read/write replica

2. asynchronous read replica

3. asynchronous read replica

1 & 2 will be always up running status, but 3 replica I want to up when have heavy traffic load on both existing nodes manually.

My doubts are given below.

Can above mention scenario supported by MS SQL 2016?

If yes,  So how the 3rd replica will up and replicate\sync the data from Primary replica and time for up?

Thanks

Subhash

0 Kudos
0 Replies