- We recommend that you test hotfixes before you deploy them in a production environment.
- We recommend that you apply the most recent update release .
- This cumulative package is intended to correct only the problems that are described in this article. Apply it only to systems that are experiencing these specific problems.
- The most recent update release contains all the hotfixes and all the updates that were included with the previous SQL Server 2014 update release.
- We recommend that you upgrade your SQL Server to the next SQL Server 2014 service pack .
Hybrid environments deployment
- SQL Server failover cluster rolling update and service pack process.
If you do not want to use the rolling update process, follow these steps in order to apply a CU or SP:
- Install the service pack on the passive node.
- Install the service pack on the active node (This step requests service restart).
- Upgrade and update of availability group servers that use minimal downtime and data loss.
If you enabled AlwaysOn with SSISDB catalog for additional considerations about how to apply a CU or SP in these environments, see the information about SSIS with AlwaysOn.
- How to apply a hotfix for SQL Server in a transactional replication and database mirroring topology
- How to apply a hotfix for SQL Server in a replication topology
- How to install service packs and hotfixes on an instance of SQL Server that is configured to use database mirroring
- Overview of SQL Server Servicing Installation
PrerequisitesTo apply this cumulative update package, you must be running SQL Server 2014 SP1.
Restart informationYou may have to restart the computer after you apply this cumulative update package.
Registry informationTo use one of the hotfixes in this package, you do not have to make any changes to the registry.
- How to obtain the latest service pack for SQL Server 2014.
- The Incremental Servicing Model for SQL Server to deliver hotfixes for reported problems.
- Naming schema for Microsoft SQL Server software update packages.
- Description of the standard terminology that is used to describe Microsoft software updates.
Article ID: 3075950 - Last Review: Apr 17, 2017 - Revision: 2