We have a replication setup for a table which is 250 GB in size and it has about 1.7 billion rows. There are three subscribers for this publication. Since about a week, we are getting validation error such as below for that publication.
Table 'Tablename' may be out of synchronization. Rowcounts (actual: 1708770888, expected: 1708765204). Rowcount method 0 used (0 = Full, 1 = Fast).
We also did actual row count on that table with count(*) but that exactly matches for publisher and all three subscriber.
The main concern is that the difference between actual and expected is increasing daily since we started getting error.
We are lost on why we are getting validation error with full row count error but when we do count(*) on publisher and three subscriber tables then it matches. This is a very strange issue. Any help will be greatly appreciated...
Thanks.