Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  Replication error recovery

Author  Topic  osaleh Starting Member 2 Posts Posted - 2005-02-17 : 15:30:35 I am running bi-directional replication. For some reason, the data that I started with with not in sync at both centers. What happened next is that a record was updated in once center that did not exist in the other center. The distributer ofcourse failed. Now, if I go and add it to the other center it will replicate the action as Add and then it will fail again when it replicates through. How am I supposed to recover from this? My other question is can I get rid of one transaction being replicated and then continue with the rest. For example, i have done transaction1, 2, 3. T1 failes, T2 & T3 are waiting to be replicated. Can I remove T1 from the distributor so that T2 & T3 can continue? please help.