DetailPage-MSS-KB

Microsoft small business knowledge base

Article ID: 941232 - Last Review: February 28, 2014 - Revision: 3.0

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

Applies to
  • 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
Keywords: 
kbexpertiseinter kbsql2005repl kbexpertiseadvanced kbhowto kbinfo KB941232
Share
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support