August 26, 2005 at 12:23 pm
Subscriber Data <> Publisher Data (The heading dropped my <> )
My customer table on the publisher has the exact same # of records as the subscriber (good) but when I run a query to select a sub-set of records, I have more records selected at the publisher than the subscriber (very bad). I can see that data in certain fields is different between the 2.
Transactional replication (last snap shot resync on Aug 4, pull runs every 15 min during business hours
All I can think of is:
I thought perhaps somebody did a rogue update at the subscriber, but SQL Diagnostic Manager doesn't show any updates since the last snapshot synched them up on 8-04
Also, another subscribed database(subscriber2) has a similar count as subscriber1, so both replicated tables are similar in how they mis-match against production.
I know some activities are not logged, but if the records are there, but data is different, it appears that an update of some sort did not get logged & replicated ?!?!
Any ideas ?
SQL2K sp3a
August 30, 2005 at 8:36 am
Never mind .... I found the "problem" ..... It wasn't replication related.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply