trans. rep. not in synch | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

trans. rep. not in synch

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.
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.
I suggest to delete the current replication and enable afresh.
(please make sure to post replication question in relevant forum) Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.