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

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
속성

문서 ID: 941232 - 마지막 검토: 2014. 2. 28. - 수정: 1

피드백