Скачать или смотреть How to Safely Update SQL Server to the Latest CU (Step-by-Step)

Keeping your SQL Server secure, stable, and high-performing requires staying current with Cumulative Updates (CUs). In this tutorial, I’ll guide you step-by-step through how to safely update SQL Server to the latest CU -- covering preparation, backups, downloading the update, and both interactive and silent remote installation methods using PowerShell and SSH. Whether you're managing SQL Server 2019, 2022, or newer versions, this guide will help you avoid downtime and ensure a smooth upgrade.


Applies to:
✅ SQL Server 2022, 2019, 2017, 2016, 2014, 2012
✅ Windows Server 2025
✅ Windows Server 2022
✅ Windows Server 2019


Chapters:
0:00 Introduction
0:35 Preparation and Backup
2:04 Obtain the Latest CU
3:32 Apply CU: Interactive Installation
4:28 Apply CU: Silent, Remote Installation (PSSession)
6:20 Apply CU: Silent, Remote Installation (SSH)
7:28 Thank you for watching
7:50 Links


Glossary:
UAC = User Account Control
SHA = Secure Hash Algorithm
SSH = Secure Shell
CU = Cumulative Update (roll-up package containing latest fixes)
GDR = General Distribution Release (critical security updates only)


Scripts + Commands on GitHub:
https://github.com/DariensTips


Commands:
winget list --upgrade-available
winget update –-all

sqlcmd -S localhost -E -Q "SELECT @@VERSION"
sqlcmd -S localhost -E -Q "SELECT name FROM sys.databases"

sqlcmd -S localhost -E -Q "BACKUP DATABASE [YourDatabaseName] TO DISK = '[path]\[filename].bak' WITH INIT, STATS = 10"

Get-FileHash sqlserver[xxxx]-kb[xxxx]-x64_[sha1hash].exe
Get-FileHash sqlserver[xxxx]-kb[xxxx]-x64_[sha1hash].exe -Algorithm sha1

$sql01Session=New-PSSession [servername]
Enter-PSSession -Session $sql01Session
([Security.Principal.WindowsPrincipal][Security.Principal.WindowsIdentity]::GetCurrent()).IsInRole([Security.Principal.WindowsBuiltInRole]::Administrator)


Links:
https://learn.microsoft.com/en-us/tro...
https://learn.microsoft.com/en-us/tro...
https://catalog.update.microsoft.com/...
https://learn.microsoft.com/en-us/tro...


Hashtags:
#SQLServer #SQLServerUpdate #PowerShell #CumulativeUpdate #DatabaseAdministration