April 7, 2010 at 11:35 pm
We have one publisher(SQL Server 2005) and many subscribers(SQL Server 2005),we are facing problem during synchronization in which some time data could not be propogated to the publisher even though replication is running successfully,means data missed during insertion or updation.
do any body have any clue about this.
please reply with your suggestion and reason.
April 8, 2010 at 8:12 am
Maya,
unless you talk in detail about your replication setup, I am not sure how we can help. You haven't even written what kind (merge or tran) replication do you have, forget about what type of changes get lost.
You will need to answer many questions since problems like these (in our lingo called as "replication non-convergence") are the hardest to troubleshoot:
> what type of replication? how many subscribers? what type of subscribers (pull or push or anonymous)
> what type of changes get lost (inserts or deletes or updates)?
> does it happen to only some subscribers or all?
> what is the pattern of changes getting lost?
> Is the publisher schema different than subscribers?
> Does the publication have filters defined on it? if yes, is it dynamic filtering?
Let us know.
-Mangesh
April 8, 2010 at 8:18 am
If this is transactional replication.
Have a look at agent history on the distributor, there will be a job for the snap-shot , log reader and one job for each subscriber.
Check these for errors, you say that data is not being propogated to the publisher, do you mean 'by' the publisher?
April 9, 2010 at 3:59 am
Hi,
Answers of ur questions are:
>We are using merge Replication and there are 10 Subscribers having anonymous replication
>Any change (update or insert record in table) occurr on subscribers some time missed on publisher
>Not on all subscibers (only on two or three subscibers)
>Not specific pattern(any change)
>Replcation Publisher schema is not different than subscribers otherwise it can be.
>Publication have no filters defined on it.
Waiting for your Reply.
Thank U!
April 16, 2010 at 2:57 am
Is anyone reply on it?
May 12, 2010 at 1:07 am
Hi Mangesh,
you did not reply till yet as i have given Answers to your questions.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply