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

Issue type:

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

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

SQL Server Replication issues-the row was not found at the subscriber 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

上一篇:memcached实战系列(五)Memcached: List all keys 查询所有的key


下一篇:shell--3.运算符