Overview of SQL Server Servicing Installation
Applies To: SQL Server 2016
You can apply an update to any installed SQL Server 2016 component with a SQL Server 2016 servicing update. If the version level of an existing SQL Server 2016 component is later than the update version level, the Setup program will exclude it from the update. For more information on applying a servicing update, see Install SQL Server 2016 Servicing Updates.
The following considerations apply when you install SQL Server 2016 updates:
All features that belong to an instance of SQL Server must be updated at the same time. For example, when you update the Database Engine, you must also update Analysis Services and Reporting Services components if they are installed as part of the same instance of SQL Server. Shared features, such as Management Tools, SQL Server Data Tools (SSDT), and SQL ServerIntegration Services, must always be updated to the most recent update. If a component or instance in the feature tree is not selected, the component or instance will not be updated.
By default, SQL Server 2016 update log files are saved to %Program Files%\MicrosoftSQL Server\130\Setup Bootstrap\LOG\.
SQL Server setup can now integrate an update with the original media to run the original media and the update at the same time.
Before you apply a SQL Server 2016 servicing update, we recommend that you consider backing up your data.
SQL Server updates are available through Microsoft Update. We recommend that you scan for updates regularly to keep your instance of SQL Server updated and secure. SQL Server 2016 SP1 is being provided as a complete SQL Server Installation. Rather than providing the Service Pack in the standard Patch executable package to be applied to SQL Server 2016 RTM instances, for this release, an installation package (consisting of 2 files) is provided. When executed, this will install a new instance of SQL Server with SP1 pre-installed.
The recommended disk space requirements are approximately 2.5 times the size of the package to install, download, and extract the package. After installing a service pack, you can remove the downloaded package. Any temporary files are removed automatically.
Review the known issues: For more information about the known issues for the current release, see the corresponding release notes topic here: SQL Server Release Notes.
This section discusses the SQL Server 2016 installation for cumulative updates and service packs, including how to do the following:
Prepare for a SQL Server 2016 update installation
Install SQL Server 2016 updates
Restart services and applications
We strongly recommend that you do the following before you install SQL Server 2016 updates:
Back up your SQL Server system databases — Before you install SQL Server 2016 updates, back up the master, msdb, and model databases. Installing a SQL Server 2016 update changes these databases, making them incompatible with earlier versions of SQL Server 2016. Backups of these databases are required if you decide to reinstall SQL Server 2016 without these updates.
It is also prudent to back up your user databases.
When you apply updates to instances of SQL Server that participate in a replication topology, you must back up your replicated databases together with your system databases before you apply the update.
Back up your Analysis Services databases, configuration file, and repository — Before you update an instance of Analysis Services, you should back up the following:
Analysis Services databases. By default, these are installed to C:\Program Files\MicrosoftSQL Server\MSAS13.<InstanceID>\OLAP\Data\. For WOW installation, the default path is C:\ProgramFiles (x86)\ MicrosoftSQL Server\MSAS13.<InstanceID>\OLAP\Data\.
Analysis Services configuration setting in the msmdsrv.ini configuration file. By default, this is located in the C:\Program Files\MicrosoftSQL Server\MSAS13.<InstanceID>\OLAP\Config\ directory.
(Optional) The database that contains the Analysis Services repository. This step is required only if Analysis Services was configured to work with the Decision Support Objects (DSO) library.
Failure to back up your Analysis Services databases, configuration file, and repository will prevent you from reverting an updated instance of Analysis Services to the earlier version.
Verify that the system databases have sufficient free space — If the autogrow option is not selected for the master and msdb system databases, these databases each must have at least 500 KB of free space. To verify that the databases have sufficient space, run the sp_spaceused system stored procedure on the master and msdb databases. If the unallocated space in either database is less than 500 KB, increase the size of the database.
Stop Services and Applications — To avoid a possible restart of the system, stop all applications and services that make connections to the instances of SQL Server that are being upgraded, before installing SQL Server 2016 updates. These include SQL Server Management Studio, SQL Server Data Tools (SSDT). For more information, see Start, Stop, Pause, Resume, Restart the Database Engine, SQL Server Agent, or SQL Server Browser Service.
You cannot stop services in a failover cluster environment. For more information, see the failover cluster installation section later in this topic.
To eliminate the requirement to restart your computer after update installation, Setup will show a list of processes that are locking files. If the update Setup program must end a service during installation, it will restart the service after the installation finishes.
If Setup determines that files are locked during installation, you might have to restart your computer after the installation finishes. If it is required, Setup prompts you to restart your computer.
This section describes the installation process.
To install a SQL Server 2016 update, run the self-extracting package file.
Cumulative update package (CU): <SQLServer2014>-KBxxxxxx-PPP.exe
Service pack package (PCU): <SQLServer2014><SPx> -KBxxxxxx-PPP-LLL.exe
x indicated service pack number
PPP indicates the specific platform.
LLL indicates the character abbreviation for the SQL Server language, for example: LLL for English is ENU.
To apply updates to SQL Server 2016 components that are part of a failover cluster, see the section for failover cluster installation. For more information about how to run an update installation in unattended mode, see Install SQL Server 2016 from the Command Prompt.
Product Update is a feature in SQL Server 2016 Setup. It integrates the latest product updates with the main product installation so that the main product and its applicable updates are installed at the same time. Product Update can search Microsoft Update, Windows Server Update Services (WSUS), a local folder, or a network share for applicable updates. After Setup finds the latest versions of the applicable updates, it downloads and integrates them with the current SQL Server setup process. Product Update can pull in a cumulative update, service pack, or service pack plus cumulative update. Product Update functionality is an extension of the Slipstream functionally that was available in SQL Server 2008 PCU1.
You can apply an update to an unconfigured prepared instance of SQL Server without completing the configuration of the prepared instance. Different ways of applying an update to a prepared instance of SQL Server are explained below:
Updating a previously prepared instance of SQL Server
Updates to a prepared instance can be applied to prior to configuration. The update package detects that the instance is in the prepared state and apply the patch to the prepared instance, without completing the configuration.
Updates to a prepared instance using Microsoft Update:
You can apply updates to a prepared instance of SQL Server through Microsoft Update. The Microsoft Update package will detect that the instance is in the prepared state and apply the patch to the prepare instance without completing the configuration.
If you are updating a prepared image of SQL Server, you will need to specify the InstanceID parameter. For more information and sample syntax, see Installing Updates from the Command Prompt.
Updating a completed and configured instance of SQL Server follows the same processes as any other installed instances of SQL Server.
If you must rebuild a node in the failover cluster after updates were applied, follow these steps:
Rebuild the node in the failover cluster. For more information about rebuilding a node, see Recover from Failover Cluster Instance Failure.
Run the original SQL Server 2016 Setup program to install SQL Server 2016 on the failover cluster node.
Run SQL Server 2016 updates Setup on the node that you have added.
When the Setup program is finished, it might prompt you to restart the computer. After the system restarts, or after the Setup program finishes without requesting a restart, use the Services node in Control Panel to restart the services that you stopped before you applied the SQL Server 2016 updates. This includes services such as Distributed Transaction Coordinator and the Microsoft Search services, or instance-specific equivalents.
Restart the applications that you closed before you ran SQL Server 2016 update Setup. You might also want to make another backup of the upgraded master, msdb, and model databases immediately after successful installation.
You can uninstall SQL Server 2016 cumulative updates or service packs from Programs and Features in Control Panel. To view the list of updates installed, open Installed Updates by clicking the Start button, clicking Control Panel, clicking Programs, and then, under Programs and Features, clicking View installed updates. Each cumulative update is listed separately. However, when a service pack is installed that is higher than the cumulative updates, the cumulative update entries are hidden and become available only if you uninstall the service pack.
To uninstall any service packs and updates, you must start with the latest update or service pack applied to the instance of SQL Server and work backward. In each of the following examples, SQL Server ends up with Cumulative Update 1 after uninstall has been completed for the other service packs or updates:
For an instance of SQL Server 2016 with Cumulative Update 1 and SP1 installed, uninstall SP1.
For an instance of SQL Server 2016 with Cumulative Update 1, SP1, and Cumulative Update 2 installed, uninstall Cumulative Update 2 first and then uninstall SP1.