SQL Server 2014 SP2 Update – Silent Install

SQLServer2014SP2-KB3171021-x64-ENU.exe /Quiet /IAcceptSQLServerLicenseTerms /Action=Patch /AllInstances

Long story short, you should reboot the server twice, before and after running the command.

Thanks,
Hiram

If you want to keep reading, keep going.

The installation summary file can be found here, which you can double check the status of the update:

C:\Program Files\Microsoft SQL Server\120\Setup Bootstrap\Log\Summary.txt

First time I tried this, the cmd shell closes very fast and I couldn’t apply the update because the command shell was erroring with exit message: “A computer restart is required.” Meaning, there was a reboot pending before the update can be installed.

With a quick finger on the PrintScreen key, I was able to capture the command shell message. Alternatively, you can run psr.exe (Steps Recorder) and hit record.

rebootpending

Ran “shutdown /f /r /t 00” to reboot right away, but here is the top contents of the Summary.txt Log File: C:\Program Files\Microsoft SQL Server\120\Setup Bootstrap\Log\Summary.txt

Overall summary:
Final result:                  Passed but reboot required, see logs for details
Exit code (Decimal):           -2067919934
Exit facility code:            1214
Exit error code:               3010
Exit message:                  A computer restart is required. You must restart this computer before installing SQL Server.
Start time:                    2017-02-01 17:06:42
End time:                      2017-02-01 17:07:10
Requested action:              Patch

After rebooting, I retired initial command above.

The SQL2014 SP2 update installs successfully but doesn’t actually apply. My server instance still showed 12.0.4100.1. The cmd shell message said:

restarttocomplete

For sanity, I tried bouncing the SQL services installed to see if the build reflects changed but no dice. If you need the net stop & net start cmds I ran here they are:

Note: Powershell cmdlet Restart-Service does the same thing, but I like the stop/start controlled method and since I was already in cmd shell, heck why not use NET STOP & NET START cmds.

NET STOP SQLSERVERAGENT
NET STOP MSSQLSERVER
NET STOP sqlbrowser
NET STOP MSSQLFDLauncher
NET STOP "MsSqlServerOlapService"
NET STOP "ReportServer"
NET STOP MsDtsServer120

NET START "MsSqlServer"
NET START "SQL Server Agent (MsSqlServer)"
NET START MsDtsServer120

After bouncing the services the SQL instance still showed build 12.0.4100.1. I proceeded to reboot, Start, Power, Restart (Reason: Application Maintenance). When the server came back online the new SQL Server build reflected SQL2014SP2 version 12.0.5000.0. Done!

Checked the top contents of the Summary.txt Log File: C:\Program Files\Microsoft SQL Server\120\Setup Bootstrap\Log\Summary.txt

Overall summary:
Final result:                  Passed
Exit code (Decimal):           0
Start time:                    2017-02-01 18:50:32
End time:                      2017-02-01 18:55:02
Requested action:              Patch

Instance MSSQLSERVER overall summary:
Final result:                  Passed
Exit code (Decimal):           0
Start time:                    2017-02-01 18:51:14
End time:                      2017-02-01 18:54:59
Requested action:              Patch


Just as an advice, when doing this for previous projects always check post the update for active connections from applications, and rerun any missed SQL Jobs that might have been halted or missed during the servicing.

If you don't use the silent method above (/QUIET switch) the UI will service the SQL Server instance for a few minutes (meaning SQL services will restart) while the update actually applies and the instance will reflect the new build right away.

An interesting option I'd like to see in action is /CLUSTERPassive. If you want to see all the options here they are or you can run the help on your own.


C:\Users\hiramf\cd Downloads
C:\Users\hiramf\Downloads\SQLServer2014SP2-KB3171021-x64-ENU.exe /?

Microsoft (R) SQL Server 2014 12.00.5000.00
Copyright (c) Microsoft Corporation.  All rights reserved.

Usage:
setup.exe /[option]={value} /[option]={value} ...

Options:
ACTION                       Specifies a Setup work flow, like INSTALL,
UNINSTALL, or UPGRADE. This is a required
parameter.
ALLINSTANCES                 Specifies that all instances are to be included
in the Setup operation. This parameter is
supported only when applying a patch.
CLUSTERPASSIVE               Specifies that SQL Server Setup should not manage
the SQL Server services. This option should be
used only in a non-Microsoft cluster environment.
ENU                          Use the /ENU parameter to install the English
version of SQL Server on your localized Windows
operating system.
ERRORREPORTING               Specify if errors can be reported to Microsoft to
improve future SQL Server releases. Specify 1 or
True to enable and 0 or False to disable this
feature.
HELP                         Displays the command line parameters usage
IACCEPTSQLSERVERLICENSETERMS By specifying this parameter and accepting the
SQL Server license terms, you acknowledge that
you have read and understood the terms of use.
INDICATEPROGRESS             Specifies that the detailed Setup log should be
piped to the console.
INSTANCEID                   Specify the Instance ID for the SQL Server
features you have specified. SQL Server directory
structure, registry structure, and service names
will incorporate the instance ID of the SQL
Server instance.
INSTANCENAME                 Specify a default or named instance. MSSQLSERVER
is the default instance for non-Express editions
and SQLExpress for Express editions. This
parameter is required when installing the SQL
Server Database Engine (SQL), Analysis Services
(AS), or Reporting Services (RS).
QUIET                        Setup will not display any user interface.
QUIETSIMPLE                  Setup will display progress only, without any
user interaction.
SQMREPORTING                 Specify that SQL Server feature usage data can be
collected and sent to Microsoft. Specify 1 or
True to enable and 0 or False to disable this
feature.
UIMODE                       Parameter that controls the user interface
behavior. Valid values are Normal for the full
UI,AutoAdvance for a simplied UI, and
EnableUIOnServerCore for bypassing Server Core
setup GUI block.
X86                          Specifies that Setup should install into WOW64.
This command line argument is not supported on an
IA64 or a 32-bit system.

Press any key to exit...

sql2014sp2updatehelp

For reference:

  1. If you need to check Build Numbers my favorite place is here: http://sqlserverbuilds.blogspot.com/
  2. If you need to download the update file my favorite place is here: https://www.microsoft.com/en-us/download/details.aspx?id=53168

Thanks,
Hiram

Advertisements

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s