Subscriber ahead of publisher in Transactional Replication

Last Post 19 Apr 2004 11:38 PM by MPasha. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
MPasha
New Member
New Member

--
19 Apr 2004 11:38 PM
Hi,

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.
Pasha
You are not authorized to post a reply.

Acceptable Use Policy