sql server replication: Hi,

I am trying to create custom merge profile for merge replication
between SLQ2000 and MSDE2000. The link between the two is usually 33,6
kb/s. I have checked parameters for 'Slow link profile', but there is
only one parameter different comparing to the default profile
(UploadGenerationsPerBatch).

Can somebody tell if any other parameters should be considered when
specifying slow link profile (eg. LoginTimeOut, QueryTimeOut, etc.)?

Regards

You can also in the Create Publication Wizard, select
Yes, minimize the amount of data on the Optimize
Synchronization page (@keep_partition_changes = true),
and consider if column-level tracking is appropriate for
the business needs.
The timeout parameterss are usually adjusted only when
timeouts are an issue, and won't optimize your process.
You might want to look at this article to get more info
on Optimization:
http://www.microsoft.com/technet/prodtechnol/sql/2000/main
tain/mergperf.mspx
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Hi Paul,

thanks a lot.