Post reply

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

  • February 2, 2010 at 8:25 am

    #210499

    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.

    Note: Other than reinitialization, can anybody please suggest me some appropriate way to handle this kind of issues.

    Thanks.

  • February 4, 2010 at 12:05 pm

    #1113912

    Have you validated the subscriptions? Are you doing any filtering?

    If the subscription is out of sync with the publisher, you will need to reinitialize.

    You can reinitialize without doing a snapsot. You can copy missing records, or restore a backup, ro use SSIS or whatever you like to get the two in sync. Then sbypass the initial snapshot.

    Converting oxygen into carbon dioxide, since 1955.

Viewing 2 posts - 1 through 1 (of 1 total)

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