CER Replication

Unanswered Question
May 15th, 2007
User Badges:
  • Bronze, 100 points or more

I noticed a few weeks ago, replication seems to have broken between our CER primary and subscriber. Rebooting the servers hasn't seemed to fix it.

Name resolution works fine (both via DNS and hosts file). The interesting thing is if I bring down the Publisher, the Subscriber merges its logs after the Publisher comes back up. However, changes and logs on the Publisher don't make it to the subscriber. SQL Enterprise manager shows replication errors with the message "the specified subscription type is invalid".

So my question...what type of replication should be setup on the Publisher? I see the CER1201 database being shared as a Merge publication. Is it also shared as a push/pull?

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
johnnylingo Mon, 06/04/2007 - 10:13
User Badges:
  • Bronze, 100 points or more

I deleted the push subscription from the publisher, and then it worked fine.

Replication seems to have broken around the time I upgrade from 1.2, so I'm wondering if this was just an upgrade bug. Don't know how CER 1.2 was working, but in 1.3 it uses a Pull subscription from the subscriber.


This Discussion