I have pull transactional replication under SQL 2000 to SQL2005, SQL 2000 as publisher and SQL2005 as Subscriber.
I have setup replication with 28 distribution job agent,i used pull transactional replication. every agent contains 1 or more table to be replicate. i have problem with 1 agent replication with 1 table to be replicated, it call ARAccount_Receivable. since
initial snapshot distribution agent show message "Delivering Replicated Transaction". the distribution agent was running for 11days, but the data have lastupdate since 3 days ago, means replication was running but very long time delay. this table
size have only 32 million data, if compared to the other table with have size more than 100 milion data was running normal.
Below the agent distribution profile
-BCPBatchSize : 100000
-CommitBatchSize : 1000
-CommitBatchTreshold : 1000
-HistoryVerboseLevel : 1
-KeepAliveMessageInternal : 300
-LoginTimeOut : 1000
-MaxBcpThreads : 10
View Complete Post