Subscriber data Publisher data

  • 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

  • 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