- 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?