March 12, 2012 at 1:22 am
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?
March 12, 2012 at 10:52 pm
Anyone?????? :discuss:
March 30, 2012 at 10:54 am
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.
March 30, 2012 at 11:18 am
Sounds like you have configured snapshot replication
M&M
March 30, 2012 at 9:32 pm
Yes. It is a snapshot replication.
and the problem still persists. 🙁
March 30, 2012 at 9:45 pm
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