Replication Problem : Copies all the rows everytime

  • I am having a problem in Replication

    The scenario is,

    We have a vewry big database (100GB+) there are 200+ tables and only 50 odd tables are being replicated

    We have setup a publisher and there are 10+ subscribers are getting data from there.

    Now i have to add a new subscriber.

    I followed following steps to add new push subscriber and it added it successfully. and started getting records

    - I created a blank DB on subscriber

    - Created push subscription

    - It started replication.

    but the main problem is everytime it downloads full snapshot. ie. there is one table having 20 million rows and it downloads it everytime.

    - deleted subscription

    - I restored existing backup for other tables (only after above problem encountered)

    - created new push subscription

    and still i was getting problem.

    It doesnt happen on anyother subscriber. it happens only in this subscriber.

    What am i doing wrong?

  • Anyone?????? :discuss:

  • What type of publication do you have set up? Transactional or Snapshot?

    One thing that may help is to generate scripts to see what may be different with the subscriptions.

  • Sounds like you have configured snapshot replication

    M&M

  • Yes. It is a snapshot replication.

    and the problem still persists. 🙁

  • This is expected behaviour in snapshot replication. There are other options you may consider based on your requirement. Check out this link: Types of replication

    M&M

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply