SQL Server Performance

trans. rep. not in synch

Discussion in 'Performance Tuning for SQL Server Replication' started by bfarr23, Sep 16, 2005.

  1. bfarr23 New Member

    i have a couple table on a scbscriber out of synch cause the web site accidently was pointing to the subscriber.

    how can i synch these up now?

    i do not want to drop subscriptions, etc.

  2. mulhall New Member

    More information please.

    You've got a publisher with multiple subscribers and instead of updating the publisher you were updating one of the subscribers?

    It sounds like you need to stop the current replication model, overwrite the tables on the publisher then reinitialize your subscribers.
  3. satya Moderator

    I suggest to delete the current replication and enable afresh.
    (please make sure to post replication question in relevant forum)

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page