HELp ! | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

HELp !

i have sql server 2000 transactional replication installed on a production system. 1 publisher / distributor (same box)
4 subscribers ( 4 separate db servers) got an error for one of the subcribers saying there is a violation of primary key constraint.
i check the data that gave the error and that data already exists on ALL subscribes.
i am clicking "start synchronizing" but it keeps coming back with that same error. help!

data was on pub & sub. thus used the Agent Profile "SKIP ERRORS" and set it = error in question. worked !

May check KBAhttp://support.microsoft.com/kb/813494 andhttp://www.replicationanswers.com/Transactional.asp link too. 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.
]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |