Communication Link Failure

• Adam Campbell

  SSC Eights!

  Points: 982

  More actions

  December 11, 2006 at 2:57 pm

  #97909

  Lately replication to one of our servers is failing with a message of "Communication Link Failure".  My question to everyone is that I have seen this in the past, and the only way to get past it was to reinitialize the subscription and push the entire snapshot back out again.  Unfortnately this is not acceptable because the database is very large and takes the entire day to push out a snapshot to the subscriber.  How else can I deal with this error? I don't believe it is a network problem because in the past it has never been the case.

  SQL Server 2000 transactional replication

  Thanks,

  Adam

• MohammedU

  SSCoach

  Points: 19644

  More actions

  December 11, 2006 at 5:07 pm

  #677365

  Post exact error details... mean time try the following...

  If it is not network issue try the following...

  Change the agent profile: increase your commitbatch size to 100 or 150 and try it again. If that does not work, decrease it to 1 then try...

   

  MohammedU
  Microsoft SQL Server MVP