Re: Merge replication data loss

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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: HD from relay stations
    ... network, someone has to pay. ... subscriber of yours, but can you still come and fix the cable please ?'. ... network, so he can hardly expect to receive cable channels. ...
    (uk.tech.digital-tv)
  • Re: HD from relay stations
    ... network, someone has to pay. ... I ring the cable company, and say, 'I'm not a subscriber of yours, but can you still come and fix the cable please ?'. ... network, so he can hardly expect to receive cable channels. ...
    (uk.tech.digital-tv)
  • 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)