Article ID: 981074 - Last Review: April 19, 2010 - Revision: 1.0

FIX: The DownloadGenerationsPerBatch parameter is not applied correctly in a SQL Server 2005 merge replication

View products that this article applies to.
System TipThis article applies to a different operating system than the one you are using. Article content that may not be relevant to you is disabled.
Expand all | Collapse all

SYMPTOMS

Consider the following scenario:
  • In Microsoft SQL Server 2005, you configure a merge replication.
  • You create some articles.
  • You configure Web synchronization for this merge replication.
  • You set the DownloadGenerationsPerBatch parameter of the replication merge agent to a large value. For example, you set the DownloadGenerationsPerBatch parameter to a value of 1000.
  • The subscriber_upload_options property of the articles is set to a value of 1 or a value of 2.
In this scenario, the number of generations that are processed in a single batch while downloading changes from the Publisher to the Subscriber is not the value you configured. The number of generations that are processed is a lower value, such as 200.
Back to the top

STATUS

Microsoft is aware of this problem. Microsoft regularly releases software updates to address specific problems. If Microsoft releases a software update to resolve this problem, this article will be updated with additional information.
Back to the top

REFERENCES

For more information about Web synchronization for merge replication, visit the following Microsoft Developer Network (MSDN) Web site:
Web synchronization for merge replication (http://msdn.microsoft.com/en-us/library/ms151763(sql.90).aspx)


For more information about DownloadGenerationsPerBatch, visit the "DownloadGenerationsPerBatch" section in the following MSDN Web site:
Replication merge agent (http://msdn.microsoft.com/en-us/library/ms147839(sql.90).aspx)


For more information about the subscriber_upload_options parameter, visit the "subscriber_upload_options" section of the following MSDN Web site:
The sp_addmergearticle stored procedure (http://msdn.microsoft.com/en-us/library/ms174329(v=SQL.90).aspx)
Back to the top
APPLIES TO
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Workgroup Edition
  • Microsoft SQL Server 2005 Standard X64 Edition
  • Microsoft SQL Server 2005 Standard Edition for Itanium-based Systems
  • Microsoft SQL Server 2005 Enterprise X64 Edition
  • Microsoft SQL Server 2005 Enterprise Edition for Itanium-based Systems
Back to the top
Keywords: 
kbexpertiseadvanced kbsurveynew kbfix kbqfe KB981074
Back to the top