Install SQL Server cumulative updates silently


GamesGames

Install SQL Server update silent: installing SQL Server cumulative updates is always a cumbersome, and quite daunting task. Unpacking and running the CU installer is a slow process, you have to click through a lot of screens, and it’s hard to get it to install silently. But here is how!

Learn how to install SQL Server cumulative updates (CU) silently using PowerShell opposed to the cumbersome task of running the GUI installer.

Imagine you’re installing Cumulative Update Package 13 for SQL Server 2019, or KB5005679. What you need to know is the file you downloaded (SQLServer2019-KB5005679-x64.exe) is a wrapper around the update’s setup.exe program. So any setup parameter passed on the command line, isn’t passed on to setup.exe! Therefore, the first step is to unpack the file into a temporary location from where you run the setup.

The following command unpacks SQLServer2019-KB5005679-x64.exe into the location Z:\sqlserver_cu\KB5005679:

.\SQLServer2019-KB5005679-x64.exe /X:Z:\sqlserver_cu\KB5005679

In the folder KB5005679 you’ll find the SQL Server cumulative update setup.exe file you so desperately need to install this update silently. Now only for the command line arguments…

All relevant command line arguments are in Microsofts online doc Installing Updates from the Command Prompt. For me, the minimal set I go with are:

  • /action=patch
  • /instancename=MSSQLSERVER
  • /quiet
  • /IAcceptSQLServerLicenseTerms

The /quiet switch runs the update in unattended mode, making the command to install SQL Server cumulative updates silent and unattended:

# silent and unattended install of a service pack to a specific SQL Server instance
Z:\sqlserver_cu\KB5005679\setup.exe /action=patch /instancename=MSSQLSERVER /quiet /IAcceptSQLServerLicenseTermsCode language: PHP (php)

In your deployment scenario, you can add some logic and checks to apply the update only if its ProductVersion property is higher than currently installed. You’ll need Invoke-SqlCmd for this too:

$sqlserver_version = New-Object System.Version $(Invoke-SqlCmd -Query "SELECT SERVERPROPERTY('ProductVersion') AS BuildNumber").BuildNumber
if($sqlserver_version -ne (New-Object System.Version $(Get-ItemProperty "Z:\sqlserver_cu\KB5005679\setup.exe\setup.exe").VersionInfo.ProductVersion)) {
	Z:\sqlserver_cu\KB5005679\setup.exe /action=patch /instancename=MSSQLSERVER /quiet /IAcceptSQLServerLicenseTerms
}Code language: JavaScript (javascript)
foto van Jan Reilink

About the author

Hi, my name is Jan. I am not a hacker, coder, developer or guru. I am merely a systems administrator, doing my daily SysOps/DevOps thing at cldin. With over 15 years of experience, my specialties include Windows Server, IIS, Linux (CentOS, Debian), security, PHP, websites & optimization.

0 0 votes
Article Rating
Subscribe
Notify of
2 Comments
Newest
Oldest Most Voted
Inline Feedbacks
View all comments
Tom
1 year ago

Nice. We were just looking to do something like this in our environment. I imagine you could change the local file path to a UNC share instead, right?

2
0
Would love your thoughts, please comment.x
()
x