Post reply

Replication Issue: Data missing to one of the subscriber end using Pull Subscription

  • January 29, 2010 at 11:24 am

    #140920

    Hello Experts

    We have a scenario where users have complaint that in publisher end in one of the tables for a particular user 10 records are available where as for 2 subscribers for the same user 6 each records are available.

    Please suggest how to proceed further.

    Thanks.

  • January 31, 2010 at 12:12 am

    #1111280

    Hello Friends

    Can anyone pls suggest me to rectify the issue? I don't want to go for reinitialisation.

    Please suggest me something else.

    Thanks.

  • January 31, 2010 at 5:35 am

    #1111313

    any suggestion..?

    Thanks.

  • February 1, 2010 at 9:26 am

    #1111716

    You could drop just that article and then add it back and run the snapshot agent. That would basically re-initialize just that article. It wouldn't explain the issue, but it should get the data back in sync. The users aren't comparing the data immediately after entering it, right?

  • February 1, 2010 at 9:33 am

    #1111729

    The 3/4 entries which I mentioned earlier are missing, against one of the a/c nos. Reinitialization is always good...but drawback would be that, no data will be available to the pulling subscriber end, unless and until the full refresh takes place. Also, data will be huge, so it will take hours togethe to gather the data at the subscriber end.

    Thanks.

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

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