TABLE 2 Changed Values for the Replication Agent Profile Details Screen
Parameter Changed Value
Name Snapshot_Speed
Description Increased BcpBatchSize, MaxBcpThreads, QueryTimeout
BcpBatchSize 200,000 (from 100,000)
MaxBcpThreads 20 (from 1)
QueryTimeout 5000 (from 300)