You are currently offline, waiting for your internet to reconnect

Your browser is out-of-date

You need to update your browser to use the site.

Update to the latest version of Internet Explorer

How to apply a hotfix for SQL Server in a replication topology

Extended support for SQL Server 2005 ends on April 12, 2016

If you are still running SQL Server 2005 after April 12, 2016, you will no longer receive security updates and technical support. We recommend upgrading to SQL Server 2014 and Azure SQL Database to achieve breakthrough performance, maintain security and compliance, and optimize your data platform infrastructure. Learn more about the options for upgrading from SQL Server 2005 to a supported version here.

INTRODUCTION
This article describes how to apply a hotfix for Microsoft SQL Server in a replication topology. In a replication topology, you may have to apply a hotfix to different servers.
More information
You apply a hotfix to one or more of the following servers in a replication topology:
  • The Distributor
  • The Publisher
  • The Subscriber
  • The Web server
Note The purpose of the hotfix determines the servers to which you apply the hotfix.

After you apply the hotfix, you may have to follow additional steps to completely resolve the problem for which you apply the hotfix. The Microsoft Knowledge Base article that describes the hotfix describes these additional steps.

In a replication topology, you can apply any hotfix for SQL Server to the Distributor or to the Publisher. However, if you have more than one version of SQL Server installed, you must also meet the following requirements:
  • After you apply the hotfix, the version of SQL Server on the Distributor must be later than or the same as the version of SQL Server on the Publisher.

    Note Typically, the Distributor is the same server as the Publisher.
  • After you apply the hotfix, the version of SQL Server on the Publisher must be earlier than or the same as the version of SQL Server on the Distributor.
The SQL Server version requirement for the Subscriber after you apply a hotfix depends on the type of publication. If you have a read-only Subscriber to a transactional publication, you can apply any hotfix to the Subscriber. If you have a Subscriber to a merge publication, the version of SQL Server on the Subscriber must be earlier than or the same as the version of SQL Server on the Publisher after you apply the hotfix.

When you use Web synchronization to replicate to one of the following destinations, you must apply a hotfix on a Web server that hosts the replication components:
  • A SQL Server Subscriber
  • A SQL Server CE database
  • A SQL Server Mobile Edition database
  • A SQL Server Compact Edition database
Properties

Article ID: 941232 - Last Review: 02/28/2014 02:12:00 - Revision: 3.0

  • Microsoft SQL Server 2012 Enterprise
  • Microsoft SQL Server 2012 Standard
  • Microsoft SQL Server 2012 Developer
  • SQL Server 2012 Enterprise Core
  • Microsoft SQL Server 2012 Business Intelligence
  • Microsoft SQL Server 2012 Web
  • Microsoft SQL Server 2012 Express
  • Microsoft SQL Server 2008 R2 Enterprise
  • Microsoft SQL Server 2008 R2 Standard
  • Microsoft SQL Server 2008 R2 Developer
  • Microsoft SQL Server 2008 R2 Express
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Enterprise Evaluation
  • Microsoft SQL Server 2008 Express
  • Microsoft SQL Server 2008 Express with Advanced Services
  • Microsoft SQL Server 2005 Workgroup Edition
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Express Edition
  • kbexpertiseinter kbsql2005repl kbexpertiseadvanced kbhowto kbinfo KB941232
Feedback