SQL Replication - General Network Error

Hi All

During the day when our internet traffic is high we reguarly get 'General Network Error - Check your network documentation' when our server in Asia performs a push replication to America.

Does anyone know why this is, and of any settings we can use, because after about 6 attempts it just gives up, and the syncronise has to be manually started again. Any timeout settings or retry settings we can set?

Replication newbie

Thanks
gravity100Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
danblakeConnect With a Mentor Commented:
Not sure what you mean by pre-synced option though?
Both sites have the data-already and you are not using the snapshot component within the system when sites get out of sync...


Its also possible to verify a batch of commands that have been sent down and get them applied to prevent big delays and increase the replication
have a look at the following other distribution agent profile vars:
-CommitBatchSize
-CommitBatchThreshold
-MaxDeliveredTransactions

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/replsql/replmon_8xk5.asp
0
 
danblakeCommented:
Yeah, there are some timeouts you can use...
In the distribution job add the following -QueryTimeOut 0
/*This will keep the replication up, and prevent the distribution from failing*/
You'll find a row in the distribution job which says : distribution -<option> <value>
or modify the default distribution profile in SQL Server (using EM).

I would also highly recommend looking at the bandwidth usage on your firewall.. If this is too high -- you're going to get problems...


The big question is why are you trying to syncronise between Asia and America via Snapshot replication ! (Bit of a problem usually better to use the pre-synced option...)
0
 
gravity100Author Commented:
Hi

Snapshot replication? I am using transaction replication (push one way only). Not usre what you mean by pre-synced option though? :(. Thanks for the other infor though :)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.