Creating Subscriber where publisher database is in AlwaysOn and NOT running in "Original Publisher" node

• Satheesh E.P.

  SSCrazy

  Points: 2509

  More actions

  January 29, 2018 at 4:52 am

  #343073

  Hi All,

  My publisher database is in AlwaysOn and let say it as ServerA which has (Node1, Node2 and Node3).  We had setup replication and the distributor server is ServerB and Subscriber is ServerC.

  Node1 is the "Original Publisher" for replication publisher but now the AlwaysOn had failed over to Node2 (in AG).  Redirection of publisher is set and the replication is working fine.

  Now I am trying to setup another subscription in ServerC for the same publisher, ServerA.

  Now can I run the "EXEC sp_addsubscription" on the Node2 which is not the Original Publisher for replication and primary in AG to create the subscription or is it mandatory to fallback AG to the "Original Publisher" node and then add the subscription?

  Thanks in advance.

  Satheesh.

  ---------------------------------------------------
  Thanks,
  Satheesh.

• Satheesh E.P.

  SSCrazy

  Points: 2509

  More actions

  January 31, 2018 at 11:36 pm

  #1978130

  In this case, we have to create the subscriber pointing to "Original Publisher" though we are active on different node in AG.

  ---------------------------------------------------
  Thanks,
  Satheesh.