Configure Transactional replication on AAG or FCI

• Minaz Amin

  SSChampion

  Points: 11052

  More actions

  December 15, 2014 at 5:17 am

  #299422

  Hi All,

  We are planning to setup HA using either AAG or FC.

  ON my production environment (P), I have transnational replication configured for 2 of databases out of three. These data get replicated to another server( C1) hosted on cloud, with local distributor at P.

  If I configure AAG/ FCI , how do I handle failover?

  I wanted to setup P as primary AAG with two replicas as S1 and S2. P->S1 will be synchronous while P->S2 will be asynchronous.

  Incase my P goes down how the replication will failover S1? Incase P and S1 goes down how do I failover to S2 with the replication.

  "More Green More Oxygen !! Plant a tree today"

• jpcaudill

  SSC Rookie

  Points: 44

  More actions

  January 15, 2015 at 6:31 am

  #1770438

  Hello,

  Did you ever figure this out - especially what happens in a failover?

  Thanks!