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

时间:2023-03-08 23:21:27
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