Post reply

Turning off a subscriber when a publisher is no longer available.

  • January 12, 2009 at 11:57 am

    #99457

    I have inherited a SQL 2000 snapshot push replication scheme, where the Publisher was just taken offline permanently. How can I turn off the replication push from the subscriber?

    Thanks!

    Brandon.Forest@hp.com

    Brandon_Forest@sbclgobal.net

    😉

  • January 14, 2009 at 8:49 am

    #926635

    Hi,

    Surely the push is going from the publisher therefore once this is disabled the subscriber no longer receives the snapshot data..or am I missing something ??

    Graeme

  • January 14, 2009 at 4:28 pm

    #927000

    The subscriber was throwing an error because it was trying to synchronize with the publisher, but couldn't find the next replicationID. Another developer on our team came up with the work around. We removed the replication constraint on all the tables in the database, with the result of effectively shutting down replication on the subscriber. The application was able to hook up after that.

    🙂

Viewing 3 posts - 1 through 2 (of 2 total)

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