General Network Error

  • I have replication between two servers.

    • Server A is both publisher and distributor and uses push transactional replication.
    • Server B is the other side of a firewall and receives the subscription that is pushed to it.

    Every now and again replication breaks with a message that says "General Network Failure". The servers are within a hosting company so information on how or why this happens simply isn't available.

    So far I have been re-initialising the subscription and generating a new snapshot to get around this but this is a very long winded way of doing things.

    Is there a quick way of telling Server A to restart replication?

    Thanks

  • Depends on what access you have. You could set the job to retry more times if it fails, or set an alert to restart the job on this particular error. For transactional there is no need to redo the snapshot, just get the logreader and distrib agents going again - as long as the subscription has not expired.

    Andy

    http://www.sqlservercentral.com/columnists/awarren/

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

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