Replication

• sqlguru

  SSC-Addicted

  Points: 471

  More actions

  August 24, 2022 at 9:59 pm

  #4080292

  I have remote distribution server which I need High availability. However, I can configure Failover cluster but is it possible to configure between 2 data centers?

• Ant-Green

  SSC Guru

  Points: 113507

  More actions

  August 25, 2022 at 6:04 am

  #4080360

  If your running SQL2016 or above look at putting distribution into an AOAG to provide both HA and DR.

   

  https://docs.microsoft.com/en-us/sql/relational-databases/replication/configure-distribution-availability-group?view=sql-server-ver16

• August 30, 2022 at 9:36 am

  This was removed by the editor as SPAM