two log reader agents in the same publisher

• abdalah.mehdoini

  Ten Centuries

  Points: 1028

  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: 113563

  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?