We have Transactional replication set up between an OLTP Database server 'A' and reporting DB server 'B', where the Data from OLTP DB(Size 400 GB) "AR" is getting replicated on the server B as database "ARB".
There have been issues reported saying for the Data mismatch on the subscriber database ARB. As per them the latest data is for last two weeks and it should have been the latest instead.
We tried to figure if replication is broken or any error message at publisher or subscriber, but no luck.
In Replication monitor the status shows 'OK'
And status "Running"; Performance "Excellent" and latency varies between 2-3 seconds.
Please help me on how can i find for what could have been possibly going wrong where data does not match between both the DB.
I am new on Tran Replication, any inputs/helps would be appreciated, thanks!