How do I shift primary Replication publisher to new node in AG

• Narodul

  SSC Enthusiast

  Points: 176

  More actions

  September 23, 2021 at 6:09 am

  #3932076

  Hi,

  Consider this setup, with SQL 2017 Enterprise, in a multi-subnet environment:

  • SERV01 (Primary) and SERV02 (Secondary)
  • Clustered as ServCluster.  There is one AG - SQLAG, with multiple databases.  There is a listener - SQLList.

  Two of the databases in the AG, DB1 and DB2, are transactionally replicated to a remote Subscriber, SERVSub.  The distributor exists on the subscriber.  SERV02 is the original publishing server.

  Question: Can the two original servers in a two-node AG be replaced with two new servers, without having to rebuild Replication.  If so, how?  I cannot find any documentation on this, even whether it is possible.

  I have replaced the machines in another two-node AG, without Replication, no problem.  But, how do I tell Replication that the original publisher is no longer SERV02 but one of the new machines (SERV03 or SERV04).

  Thanks

• Site Owners

  SSC Guru

  Points: 80330

  More actions

  September 24, 2021 at 6:10 am

  #3932421

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.