Merge replication - Check network document

From: Paul Ibison (Paul.Ibison_at_Pygmalion.Com)
Date: 07/24/04

  • Next message: Paul Ibison: "Replication Failure with Event ID 203" 
    Date: Sat, 24 Jul 2004 09:53:49 -0700

    Nathan,
    to verify that there is a network issue, you can run a
    ping -t for a day and then look at the statistics to see
    if a hicup occured.

    You could run a tsql script:

    WHILE 1<>2
    BEGIN
    SELECT GETDATE()
    WAITFOR DELAY '00:00:01'
    END
    GO

    As it looks like a network issue, in this case I'd set the
    step 3 to go to step 1 on the merge agent's job,
    effectively automatically restarting the job on a network
    error, which fixes the problem almost all the time.

    HTH,
    Paul Ibison

  • Next message: Paul Ibison: "Replication Failure with Event ID 203"

    Relevant Pages

    • Re: how can i locate a system using the h/w address
      ... Ping the problem IP# to verify that something is actually using it. ... listed in both DNS and WINS and delete those entries. ... > server....as i have a list of all ip addresses used on our> network which is statically setup. ...
      (microsoft.public.win2000.networking)
    • Re: SMS 2.0 and SMS 2003 Running at same time in same domain.
      ... the clients are on the network. ... The operating system reported error 53: ... Possible cause: The client is offline. ... Verify that the client is connected to the network and that the SMS ...
      (microsoft.public.sms.setup)
    • Re: Simple Home Network
      ... Verify that that Client for Microsoft Networks and file and print sharing are ... installed and enabled on each computer for tcp/ip and that netbios over tcp/ip ... are trusted and the network is protected by a firewall from unwanted users. ... I have a NetGear wireless router ...
      (microsoft.public.win2000.networking)
    • Re: Error ID = 0xC00D1197, Condition ID = 0x00000000
      ... verify that you are connected to the network. ... > Some network protocols in the Player are not enabled. ... > The proxy server settings for the Player are not configured properly. ...
      (microsoft.public.windowsmedia.player)
    • Re: Publisher could not save the file to the web....
      ... - if behind a network, verify with network admin that you have ftp ... > "Publisher could not save the file to the Web, ...
      (microsoft.public.publisher.webdesign)