Install SQL Cumulative Update
| Previous Install SQL Service Pack | Manual Install | Install SNAC update Next |
|---|
FineBuild can install the latest SQL Cumulative Update as part of the SQL install process. If you do not want to include SQL Cumulative Update in your FineBuild install, then do not download it.
SQL Server Cumulative Update is written by Microsoft. It was chosen to be included in FineBuild so that the latest fixes supplied by Microsoft are available to people using SQL Server.
A Cumulative Update rolls up all fixes that have been released since the last service pack. A new CU pack is issued about every 2 months. Microsoft sometimes package the update to SQL Server Native Client (SNAC) in the cumulative update, and sometimes a separate update must be applied to update SNAC.
There should be a site standard about applying SQL Server CU packs. Microsoft now recommends that the latest CU is applied shortly after it is released. It is suggested that the latest CU is applied at the same time as Windows Update fixes are applied.
Automated installation of SQL Cumulative Update is performed by Process Id 3BA and is controlled by the parameters below:
| SQL Version | Parameter | FULL Build | WORKSTATION Build | CLIENT Build |
|---|---|---|---|---|
| SQL2019 | /SetupSPCU: | Yes | Yes | Yes |
| SQL2017 | /SetupSPCU: | Yes | Yes | Yes |
| SQL2016 | /SetupSPCU: | Yes | Yes | Yes |
| SQL2014 | /SetupSPCU: | Yes | Yes | Yes |
| SQL2012 | /SetupSPCU: | Yes | Yes | Yes |
| SQL2008R2 | /SetupSPCU: | Yes | Yes | Yes |
| SQL2008 | /SetupSPCU: | Yes | Yes | Yes |
| SQL2005 | /SetupSPCU: | Yes | Yes | Yes |
In order to maintain compatibility with older versions of SQL FineBuild, the parameter /InstSPCU: can also be used.
FineBuild also uses the following parameters to help configure SQL Cumulative Update:
| Parameter | Default Value | Description |
|---|---|---|
| /SPLevel: | see text | The Service Pack for the Cumulative Update |
| /SPCULevel: | see text | The Cumulative Update level to be applied |
The SQL Cumulative Update must be placed in the same folder as the Service Pack (eg \Service Packs\SP1).
FineBuild needs to know the name of the Cumulative Update file. File names for the Cumulative Updates in the table below are coded within FineBuild. If you want to use a more recent Cumulative Update then you must supply the file name.
| SQL Server Version | SP Level | CU Level | Folder | CU List |
|---|---|---|---|---|
| SQL2019 | RTM | CU8 | Service Packs\RTM | KB4518398 |
| SQL2017 | RTM | CU22 | Service Packs\RTM | KB4047329 |
| SQL2016 | SP2 | CU15 | Service Packs\SP2 | KB3177312 |
| SQL2016 | SP1 | CU15 | Service Packs\SP1 | KB3177312 |
| SQL2016 | RTM | CU9 | Service Packs\RTM | KB3177312 |
| SQL2014 | SP3 | CU4 | Service Packs\SP2 | KB2936603 |
| SQL2014 | SP2 | CU18 | Service Packs\SP2 | KB2936603 |
| SQL2014 | SP1 | CU13 | Service Packs\SP1 | KB2936603 |
| SQL2014 | RTM | CU14 | Service Packs\RTM | KB2936603 |
| SQL2012 | SP3 | CU6 | Service Packs\SP3 | KB3133750 |
| SQL2012 | SP2 | CU15 | Service Packs\SP2 | KB2983249 |
| SQL2012 | SP1 | CU16 | Service Packs\SP1 | KB2772858 |
| SQL2012 | RTM | CU11 | Service Packs\RTM | KB2692828 |
| SQL2008R2 | SP3 | CU2 @ | Service Packs\SP3 | KB3045316 |
| SQL2008R2 | SP2 | CU13 | Service Packs\SP2 | KB2730301 |
| SQL2008R2 | SP1 | CU13 | Service Packs\SP1 | KB2567616 |
| SQL2008R2 | RTM | CU14 | Service Packs\RTM | KB981356 |
| SQL2008 | SP4 | CU2 @ | Service Packs\SP4 | KB3045311 |
| SQL2008 | SP3 | CU17 | Service Packs\SP3 | KB2629969 |
| SQL2008 | SP2 | CU11 | Service Packs\SP2 | KB2402659 |
| SQL2008 | SP1 | CU16 | Service Packs\SP1 | KB970365 |
| SQL2008 | RTM | CU10 | Service Packs\RTM | KB956909 |
| SQL2005 | SP4 | CU5 @ | Service Packs\SP4 | KB2485757 |
| SQL2005 | SP3 | CU15 | Service Packs\SP3 | KB960598 |
| SQL2005 | SP2 | CU17 | Service Packs\SP2 | KB937137 |
| SQL2005 | SP1 | N/A | Not supported by FineBuild | N/A |
| SQL2005 | RTM | N/A | Not supported by FineBuild | N/A |
@ Three fixes for SQL Server 2008 R2 have been released since normal support for this version finished.
- KB3144114 is known within FineBuild as SQL 2008 R2 SP3 CU1
- KB3045316 is known within FineBuild as SQL 2008 R2 SP3 CU2
- KB4057113 is known within FineBuild as SQL 2008 R2 SP3 CU3, and contains the latest publicly available fixes for SQL 2008 R2
@ Three fixes for SQL Server 2008 have been released since normal support for this version finished:
- KB3144114 is known within FineBuild as SQL 2008 SP4 CU1
- KB3045311 is known within FineBuild as SQL 2008 SP4 CU2, and contains the latest publicly available fixes for SQL 2008
@ Two Security Fixes for SQL Server 2005 have been released since normal support for this version finished:
- KB2494123 is known within FineBuild as SQL 2005 SP4 CU4
- KB2716427 is known within FineBuild as SQL 2005 SP4 CU5, and contains the latest publicly available fixes for SQL 2005
If you install the KB3144114 update (which introduces support for TLS 1.2) then you must also install .Net 4.6 or higher as described in Install .Net 4.x.
You can use a more recent Cumulative Update than is known to SQL FineBuild. You must supply an additional parameter that describes the file name to be used, and set the /SPCULevel: parameter to your new CU.
| Parameter | File Name | |
|---|---|---|
| Model | SPLevel_Architecture_SPCULevel | |
| 32-bit example | /SP4X86CU5: | SQLServer2005-KB4273051-x86-ENU.exe |
| 64-bit example | /SP4X64CU5: | SQLServer2005-KB4273051-x64-ENU.exe |
The FineBuild SQL Cumulative Update includes the following items:
- Stop SQL-Related Services
- Install SQL Server Cumulative Update
- Setup Shortcut to Cumulative Update Log files
- Post Fix Tasks required after the fix is installed
The following steps show what you would have to do to install the SQL Cumulative Update manually. FineBuild does all of this work for you automatically.
The latest Cumulative Update available at the time of writing is shown in the table above. It should be expected that a further CU pack will be release about every 2 months.
Each CU is intended to be cumulative, which means (for example) there should be no need to install CU3 before you install CU4. However, it is wise to search the internet to see if any dependencies have been reported.
-
Stop all services required by the SQL Server Cumulative Update install
Right-click on My Computer and select Manage. Navigate to Services and stop all services with Start/Stop/Pause authority given in Setup Service Permissions in the FineBuild Reference Manual
-
Navigate to the SQL...\Service Packs\RTM folder
Double-click the required CU install file. E.G. To install CU2 for 32-bit servers, use the following file:
SQLServer2008-KB956717-x86-ENU
-
Welcome to the SQL Server Cumulative Update Setup
Click Next to continue
-
Accept the License Terms
Click Next to continue
-
Confirm the feature selection (all check boxes should be ticked)
Click Next to continue
-
Setup has enough information to apply the Cumulative Update
Click Patch to continue
-
Wait while the Cumulative Update is being installed
-
The update has completed
No errors should be shown. Click Next to continue
-
The Cumulative update installation is complete
The log files may be viewed if desired. Click Close to exit
Copyright FineBuild Team © 2013 - 2021. License and Acknowledgements
| Previous Install SQL Service Pack | Top | Install SNAC update Next |
|---|