I have enterprise level replication running both snapshot and transactional.
Its been identified that no of records in tables participating in transactional are more at subscriber when compared to Publisher/Distributor. But there are no errors at publisher level stating the mismatch of data and the new records updated in publisher are moving smoothly to subscribers. . .
1. Is it possible to have more records in subscribers than publisher?
2. What will be impact if subscriber is modified directly without knowledge of Publisher.
3. I cann't reinitiatize the data due to some security issues.
What can be the best solution to make sure that the data at both levels is same and synchronized.
How can i overcome such problems in future?
Thanks in Advance.