Hi All,

Using transactional replication between 2 remote sites. I am trying to find the history of a transaction from the publisher side, which did not make its way to the subscriber side.

I can't find any errors in the Agents for the subscription.

Basically we inserted a row in one table on the publisher side and it is not there on subscriber side. In Replication Monitor, under 'Number of commands waiting to be applied to Subscriber' - it is 0.

I know there are a few tables in distribution database to possibly track its history (i.e. from log reader agent to distribution agent..) but not exactly sure where to start and what commands/sps to use.

First this is I think I need to find the xact_seqno for the INSERT command? Where can I get this and then from that point how can I track it to see where it disappeared or errored out to?

Thanks in advance!

Hi dnaman,

I would recommend you firstly add the -OUTPUT parameter to the Log Reader agent and Distributor Agent to retrieve more information from the output log file.

Then follow the steps in this blog to troubleshoot the whole replication topology.

Thanks,
Lydia Zhang