Post reply

Replication problem

  • October 14, 2004 at 5:15 am

    #161656

    Hi,

    We have a server pair MF-SI01 and MF-SI02 running SQL Server 2000 SP3,

    where we have set up a push transactional replication from MFSI01 to MF-SI02

    of our database with queued updating subscriptions.

    MF-SI01 acts as a publisher and distributor, MF-SI02 is the subscriber.

    The replication to the subscriber works fine, but if the subscriber is

    updated via an insert

    in a table the on the publisher gets the following error:

    Server: "MF-SI01", ZF_6HP19-databaseDBC-error:Could not change the

    Publisher because

    the subscription has been dropped. Use sp_subscription_cleanup to clean up

    the triggers.

    for the triggers.

    (this is system error message 21161)

    Does anybody know a solution for this problem?

  • October 14, 2004 at 5:04 pm

    #526856

    Sounds like the entire replication process has got itself into a knot. You may have to drop replication and set it up again from scratch without doing the snapshot!

    Kindest Regards,

  • October 14, 2004 at 7:35 pm

    #526863

    I've tried to drop replication even reinstall SQL but the problem still there.

    The above error message is generated by Log Reader Agent when insert data from subscriber.

     

    Thank you

  • October 14, 2004 at 10:56 pm

    #526869

    Do both SQL Servers have the same service pack?

    Kindest Regards,

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply