SQL Server Performance Forum – Threads Archive

General Network Error

Dear All, I am having problem in transactional replication,the error are as follows General network error. Check your network documentation.
(Source: 202.92.1.244 (Data source); Error number: 11) Kindly help me out in this Regards
Imran.N.Khan

i think it has something to do with the timeout value of the connection? AKTHAR

These errors are not conclusive, enable Logging in Replication http://dineshasanka.spaces.live.com/blog/cns!22A79FCE82651673!289.entry —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
http://dineshasanka.spaces.live.com/

quote:Originally posted by Akthar i think it has something to do with the timeout value of the connection? AKTHAR

Thanks for replying Mr.Akhtar
Started off again but this time its not giving me any network error its replicating the data smoothly,In addition to that can you tell me minimum connectivity requirment for running replication currently we have 64k link is that enough! Thanks

There are no hard core limitation for the connectivity…it all depends on how much data you are replicating…. You may get these kinds of errors when loose the connectivity specially replication over the internet….
YOu can add another schedule to the job to run every 10 minutes along with existing schedule so that job replication will continue in case this type of errors… Following is sql 2000 doc but useful for 2005 also… Merge Replication Performance Tuning and Optimization
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/mergperf.mspx
MohammedU.
Moderator
SQL-Server-Performance.com

hi,
yep all depends on how much data is being replicated. have you enable logging? does it contain any specific error??? AKTHAR

]]>