SQL-Server-Replication-the row was not found at the subscriber end

Issue type:

1.find out the number 0x0006F18F00006082002300000000 from publication end.

2.use below script to find out which command caused the issues.

exec sp_browsereplcmds
@xact_seqno_start = '0x0006F18F00006082002300000000',
@xact_seqno_end = '0x0006F18F00006082002300000000'

3.Use the below script to delete those related commands as below:

Use distribution
delete from MSrepl_commands
where xact_seqno >= 0x0006F18F000060820023 and
xact_seqno <= 0x0006F18F000060820023

4.re-run the replication jobs

 

posted @ 2016-12-29 13:51  rosewong  阅读(642)  评论(0编辑  收藏  举报