We have Transactional replication set up between a server 'A' and server 'B', where the Data from 'A' is getting replicated on the server B as database "B".
There is an issue reporting that one row in the subscriber database 'B' is missing. I re-tried the replication several times, still that one row is missing. Other than that, everything looks fine.
Anyone has an idea?
The solution will depend on two things.
If it is a smaller table (generally speaking), you can use a data comparison tool (visual studio, Redgate SQL data compare or any other third-party tools) and sync the tables from source to target. If you have constraints, it might not work.
If you can afford downtime, you can drop this table (article) and add it back without a full snapshot of other articles in the same publication. See details here.
