How to get publisher to receive subscriber data?

• Like2SQL

  SSCommitted

  Points: 1662

  More actions

  September 24, 2014 at 4:04 pm

  #397398

  We have a Server A with database A (located in CA) acting as a publisher/distributor for a subscriber database on Server B (located in Europe) in a merge replication setup. The databases are VLDB's. Updates are merged every half hour or so, and recently there have been plenty of them at the subscriber as well.

  For various reasons we need to move the publisher database to a new updated server (also in CA) and then re-initialize the replication. My issue is that after I move the publisher database to the new server (which will take a few hours if not more at least) and if I then initialize the replication, the publisher database will push/synchronize it's data to the subscriber, causing the last few hours of subscriber updates to be lost.

  What I actually need to do is when I "turn on" the publisher, I need it to absorb the last few hours of changes from the subscribers, but then continue acting as a publisher.

  I need some guidance on how I can achieve the above. I hope I explained the problem clearly. Any tips would be appreciated.

  thanks!