two log reader agents in the same publisher

• abdalah.mehdoini

  Ten Centuries

  Points: 1015

  More actions

  December 22, 2022 at 9:50 am

  #4128806

  Hello ,

  I have a transactional replication that synchronizes to two different subscribers

  subscriber A and subscriber B

  the distribution server is a dedicated instance in AG

  Is it possible to have log reader agent For primary publication  to subscriber A

  and other log reader agent to subsciber B

  thanks

• Ant-Green

  SSC Guru

  Points: 113507

  More actions

  December 22, 2022 at 10:28 am

  #4128813

  Not possible, only one log reader is created per published database.

  What is the problem you are trying to overcome?

• January 4, 2023 at 12:03 pm

  This was removed by the editor as SPAM

• January 20, 2023 at 11:28 am

  This was removed by the editor as SPAM

• January 23, 2023 at 9:53 am

  This was removed by the editor as SPAM

• January 23, 2023 at 10:35 am

  This was removed by the editor as SPAM

• January 25, 2023 at 10:03 am

  This was removed by the editor as SPAM

• February 1, 2023 at 8:44 am

  This was removed by the editor as SPAM