Install SQL Service Pack
| Previous SQL Fixes Install | Manual Install | Install SQL Cumulative Update Next |
|---|
FineBuild can install the latest SQL Service Pack update as part of the SQL install process. If you do not want to include SQL Service Pack in your FineBuild install, then do not download it.
SQL Server Service Pack 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 Service Pack rolls up all fixes that have been released since the product was released, and has been intensively tested by Microsoft.
Up to SQL Server 2016, the first service pack for a new product tends to be released about 9 months after the product RTM date, with two or three further service packs released at about 18 month intervals. However, this frequency often varies so it is impossible to predict when or if the next service pack will be released. Because a service pack contains all fixes since the product RTM, it is only ever necessary to apply the latest service pack when performing a new install of a product.
From SQL Server 2017 onwards, no Service Packs are planned for new versions of SQL Server, and all updates to SQL Server are provided by the Install SQL Cumulative Update process.
It is recommended that the latest SQL Service Pack is always applied.
Automated installation of SQL Service Pack is performed by Process Id 3A and is controlled by the parameters below:
| SQL Version | Parameter | FULL Build | WORKSTATION Build | CLIENT Build |
|---|---|---|---|---|
| SQL2019 | /SetupSP: | Yes | Yes | Yes |
| SQL2017 | /SetupSP: | Yes | Yes | Yes |
| SQL2016 | /SetupSP: | Yes | Yes | Yes |
| SQL2014 | /SetupSP: | Yes | Yes | Yes |
| SQL2012 | /SetupSP: | Yes | Yes | Yes |
| SQL2008R2 | /SetupSP: | Yes | Yes | Yes |
| SQL2008 | /SetupSP: | Yes | Yes | Yes |
| SQL2005 | /SetupSP: | Yes | Yes | Yes |
For compatibility with older versions of SQL FineBuild, the parameter /InstSP: can also be used.
FineBuild also uses the following parameters to help configure SQL Service Pack:
| Parameter | Default Value | Description |
|---|---|---|
| /SPLevel: | see text | The Service Pack to be installed |
FineBuild needs to know the name of the Service Pack file. File names for the Service Pack in the table below are coded within FineBuild. If you want to use a more recent Service Pack then you must supply the file name.
| SQL Server Version | SP Level | Folder | Download |
|---|---|---|---|
| SQL2019 | RTM | Service Packs\RTM | There are no Service packsa issued for SQL Server 2019 |
| SQL2017 | RTM | Service Packs\RTM | There are no Service packsa issued for SQL Server 2017 |
| SQL2016 | SP2 | Service Packs\SP2 | KB4052908 |
| SQL2016 | SP1 | Service Packs\SP1 | KB3182545 |
| SQL2016 | RTM | ||
| SQL2014 | SP3 | Service Packs\SP3 | KB4022619 |
| SQL2014 | SP2 | Service Packs\SP2 | KB3171021 |
| SQL2014 | SP1 | Service Packs\SP1 | KB3058865 |
| SQL2014 | RTM | ||
| SQL2012 | SP3 | Service Packs\SP3 | KB3072779 |
| SQL2012 | SP2 | Service Packs\SP2 | KB2958429 |
| SQL2012 | SP1 | Service Packs\SP1 | KB2674319 |
| SQL2012 | RTM | ||
| SQL2008R2 | SP3 | Service Packs\SP3 | KB2979597 |
| SQL2008R2 | SP2 | Service Packs\SP2 | KB2630458 |
| SQL2008R2 | SP1 | Service Packs\SP1 | KB2528583 |
| SQL2008R2 | RTM | ||
| SQL2008 | SP4 | Service Packs\SP4 | KB2979596 |
| SQL2008 | SP3 | Service Packs\SP3 | KB2546951 |
| SQL2008 | SP2 | Service Packs\SP2 | KB2285068 |
| SQL2008 | SP1 | Service Packs\SP1 | KB968369 |
| SQL2008 | RTM | ||
| SQL2005 | SP4 | Service Packs\SP4 | KB2463332 |
| SQL2005 | SP3 | Service Packs\SP3 | KB955706 |
| SQL2005 | SP2 | Service Packs\SP2 | KB921896 |
| SQL2005 | SP1 | Not supported by FineBuild | |
| SQL2005 | RTM |
You can use a more recent Service Pack than is known to SQL FineBuild. You must supply an additional parameter that describes the file name to be used, and set the /SPLevel: parameter to your new SP.
| Parameter | File Name | |
|---|---|---|
| Model | SPLevel_Architecture | |
| 32-bit example | /SP5X86: | SQLServer2005SP5-KB4273012-x86-ENU.exe |
| 64-bit example | /SP5X64: | SQLServer2005SP5-KB4273012-x64-ENU.exe |
The FineBuild SQL Service Pack install includes the following items:
- Stop SQL Server services
- Install the latest SQL Service Pack
- Setup Shortcut to Service Pack 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 Service Pack manually. FineBuild does all of this work for you automatically.
The latest Service Pack available at the time of writing is shown in the table above. It should be expected that a further Service Pack will be release about every 10 months for versions of SQL Server that are still being supported by Microsoft.
Each SP is intended to be cumulative, which means (for example) there should be no need to install SP3 before you install SP4. However, it is wise to search the internet to see if any dependencies have been reported.
-
Stop all services required by the SQL Server Service Pack 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 folder
Select the requires Service Pack folder and double-click the required SP install file
-
The Service Pack files are extracted and initial processing takes place
-
The Welcome window is displayed
Click Next to continue
-
Accept the License Terms
Click Next to continue
-
The Feature Selection window is displayed
Normally all features should be selected, but if you want to only update a specific instance then ensure only that instance is selected. Click Next to continue.
-
The Check Files In Use window is displayed
Normally no files will be in use, but if they are then stop the relevant instances before continuing, to avoid the need to reboot the server after the Service Pack has been applied. Click Next to continue.
-
The Ready to Update window is displayed
Click Update to continue
-
Various messages are displayed while the Service pack update is in progress
-
A summary window is displayed when the update is complete
Click Next to continue
-
The Complete window is displayed
Click Close to end
Copyright FineBuild Team © 2013 - 2021. License and Acknowledgements
| Previous SQL Fixes Install | Top | Install SQL Cumulative Update Next |
|---|