Capturing errors when record is deleted on replicated database

  • We've recently started getting these errors on our the transactional side of our push replication.

    Message

    Error: 14151, Severity: 18, State: 1.

    Replication-Replication Distribution Subsystem: agent SERVERA-SERVERB-36 failed. The row was not found at the Subscriber when applying the replicated command.

    I disable these errors in the Distribution profile in order to allow replication to continue, then run a validation, and all the tables are synched. I'm wondering how I can use alerts or error logs to capture what is happening? We don't have any jobs that impact the replicated side directly, so I need to enable some sort of error capture to figure out when/where/who.

    Any help is appreciated!

  • facing same issue.

    SQL Gurus please help!!!!!!!

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply