Re: Merge replication data loss

From: Hilary Cotter (hilaryk_at_att.net)
Date: 04/02/04 

Date: Fri, 2 Apr 2004 08:37:27 -0500

general network error means your network hic cupped.

Merge replication refreshes the data on the subscriber when you send the
snapshot. This could account for the data loss. Also check the conflict
viewer to see if there is a record of conflicts which also might account for
it.

Make sure if you have any cascading deletes that they are disabled on the
subscriber.
"Tom" <tomislav.hrvoic.rimuv.dis@inet.hr> wrote in message
news:uM5NnqIGEHA.4084@TK2MSFTNGP11.phx.gbl...
> I have serious problem regarding merge replication. After couple of pull
> subscription synchronizations, data loss occurred in several tables (both
> publisher and subscriber databases).
> Publication has 62 articles, but only few are affected. Agents reports
several
> errors (including really nasty "general network failure").
> I think problem is not in dynamic or join filters, because some of those
> tables are not filtered at all.
>
> Example: with tables T1 and T2 (FK constraint) users confirmed data loss
in
> child table T2 "right after synchronization" (sometimes couple of hundreds
of
> records).
>
> So, question is how this could possibly happen (FK constraint maybe or
general
> network failure)?
>
> Any help is appreciated,
> Tom
>
>
>

Relevant Pages

  • Re: Newbie to Replication Subscriptions
    ... (even though on the network share in question "Everyone" had full rights) ... they'd get in that way but not with the localsystem account that is used by ... > publisher reads the files and bcp's them to the subscriber. ... > you are using NT authentication, the SQL Server agent ...
    (microsoft.public.sqlserver.replication)
  • Re: How to get the operator name?
    ... PhoneOperatorName returns the name from the currently connected service. ... If you are roaming you'll get the operator name of the current network which won't be the same as the "home" network to which the user is subscribed. ... subscriber has a contract with. ... cell tower owner) and I have seen it return a blank string. ...
    (microsoft.public.pocketpc.developer)
  • Re: Merge replication error
    ... > The connectivity is fine - which is proven by 4 databases on this same server replicating just fine to the same subscriber. ... >> Looks like a networking issue; when the error occurs, please try pinging the>> distributor from the subscriber, to test your network connectivity and name>> resolution. ... >> Paul Ibison ...
    (microsoft.public.sqlserver.replication)
  • ADSL RFC1483 RBE 7200 2024 private link
    ... I run a 7200 router with an ATM interface that is used for ADSL ... I would like to bridge 1 ADSL subscriber to 1 port on the 2924 in order ... to provide a private link between the network connected to the single ...
    (comp.dcom.sys.cisco)
  • Re: Southampton Uni - 0870 ....
    ... and the T&C probably say something like "The subscriber may use University's ... network for personal and academic purposes; the subscriber may not use the ... University's network for any illegal, ... Obviously if Skype inserted ...
    (uk.telecom)
Loading