This project has moved and is read-only. For the latest updates, please go here.

Previous SQL Fixes Install Manual Install Install SQL Cumulative Update Next

Install SQL Service Pack

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. 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.

It is recommended that the latest SQL Service Pack is always applied.

FineBuild SQL Service Pack

Automated installation of SQL Service Pack is performed by Process Id 3A and is controlled by the parameters below:

Install Parameter Build SQL2005 SQL2008 SQL2008 R2 SQL2012 SQL2014 SQL2016 SQL2017
SetupSP FULL Yes Yes Yes Yes Yes Yes Yes
SetupSP WORKSTATION Yes Yes Yes Yes Yes Yes Yes
SetupSP CLIENT Yes Yes Yes Yes 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
SQL2017 CTP1
SQL2016 SP1 Service Packs\SP1 KB3182545
SQL2016 RTM
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 SPLevelArchitecture_
32-bit example SP5X86 SQLServer2005SP5-KB4273012-x86-ENU.exe
64-bit example SP5X64 SQLServer2005SP5-KB4273012-x64-ENU.exe

The FineBuild SQL Service Pack 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

Manual SQL Service Pack Install

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 SQL-Related Services

1) 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.
StopServices.png

Install SQL Server Service Pack

1) Navigate to the SQL-...\Service Packs\SP1 folder, and double-click the required SP install file.
SPExplorer.png
2) The Service Pack files are extracted and initial processing takes place.
SPExtract.png
3) The Welcome window is displayed. Click Next to continue.
SPWelcome.png
4) Accept the License Terms. Click Next to continue.
SPLicense.png
5) 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.
SPFeatures.png
6) 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.
SPCheckFiles.png
7) The Ready to Update window is displayed. Click Update to continue.
SPReady.png
8) Various messages are displayed while the Service pack update is in progress.
SPProgress.png
9) A summary window is displayed when the update is complete. Click Next to continue.
SPSummary.png
10) The Complete window is displayed. Click Close to end.
SPComplete.png
Copyright FineBuild Team © 2013 - 2016. License and Acknowledgements
Previous SQL Fixes Install Top Install SQL Cumulative Update Next

Last edited Dec 16, 2016 at 3:49 PM by EdVassie, version 9