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)
 How to continue after the Error in Replication

Author  Topic 

sona
Yak Posting Veteran

68 Posts

Posted - 2004-01-28 : 00:51:49

I setup Transactional replication between two tables in two sqlservers A[master] and B.

It started working without any problem.
What i did was i inserted a record in B alone.
Then i inserted the same Record in A.
So at the scheduled synchronisation time, when the changes were propagated from A to B i got the Primary Key violation errror.

And the Job failed .i am getting all the cross marks of failure in the Replication monitor

Now i made another insertion to Table in A but it is not getting propagated.

After any error how to make the replication continue ???? without recreating the subscription





tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-01-28 : 12:17:53
Have you restarted the replication job?

Tara
Go to Top of Page
   

- Advertisement -