Transactional replication with immediate updating Subscribers problem!

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Jim Rathmann (jrathmann_at_vtti.vt.edu)
Date: 02/24/05 

Date: Thu, 24 Feb 2005 14:32:24 -0800

I am pretty new to replication and I have a slight problem
with replicating from a subscriber back to the publisher.
Scenario is as follows:

I have a publication and Distributor set up on the same
machine. The publication is set up to do Transactional
with Queueing and I am pushing the subscription to a
remote machine. That part works fine when I update the
publisher it replicates fine to the subscriber. Problem
occurs when I update the subscriber, it is suppose to
update the publisher machine. I get an error on the Queue
reader saying subscriber connection dropped and something
about using the sp_subscription_cleanup to remover
triggers. It seems that I am so close to getting this to
be working bi-directional except for that problem. Can
anyone shed some light on this for me? If you have a work
phone or email that I can get ahold of you directly that
would be great.

Thanks in advance.
   Jim

Relevant Pages

  • Re: Transactional Replication 2005
    ... replication from production database as the publisher and subscribe it to ... Create the distributor on the publisher server ... I then create the subscriber, ... the identity NFR property setting has to match between publisher ...
    (microsoft.public.sqlserver.replication)
  • Re: Sp_adjustpublisheridentityrange and resetting identity range
    ... > identity ranges you have set on your publisher. ... > ranges which will work for the lifetime of their replication solution. ... > should apply this value on the subscriber. ... >> restored the published database from a backup. ...
    (microsoft.public.sqlserver.replication)
  • Re: Merge Repl Failure - Rollback or not
    ... Looking for a SQL Server replication book? ... > Publisher box now shipped to new location. ... > Generate a single insert at subscriber and replicate. ... > Disconnecting from Subscriber 'GENDEV003' ...
    (microsoft.public.sqlserver.replication)
  • Re: Disaster Recovery for Bi-Directional Transactional Replication
    ... With un-directional replication you can have multiple publishers publishing ... If the main publisher went off line a standby publisher could go online and ... subscriber, and then you would be faced with the same question as to what ... Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)
  • Re: Bi-directional Transaction Replication or Immediate Updates
    ... is there a SQL 2005 Replication book ... occurs on the subscriber, this can be in excess of 100 ms, so its not really ... So in general if you have a small number of subscribers, a link or publisher ... Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)