How to Patch SQL Server 2019

This video shows you how to patch SQL Server 2019 with a Cumulative Update and explains why it is important. It includes how to find the latest Cumulative Update and how to determine whether you need it or not.

Why Should You Patch SQL Server?

KB4518398 - SQL Server 2019 build versions

⏱️TIMESTAMPS⏱️
0:00 Intro
0:15 Why would you want to do this?
0:44 How Microsoft maintains SQL Server
2:26 What is in the CU?
3:21 Downloading SQL Server 2019 Cumulative Update 21
3:48 Checking your CU level
4:45 Checking the default file paths
5:41 Installing the cumulative update
8:55 Checking to see if the CU was installed
9:38 Outro
9:56 Bonus Chorizo footage!

🔴 Please subscribe for more content like this!

Links to Amazon are typically monetized on my channel (affiliate links) and may return a commission of sales to me from the retailer. This is unrelated to the product manufacturer.

SOCIAL
===============================

Host, Video: Glenn Berry

[huskesh]

Sir loved your channel, the views may be less but we love your of explaining thing ❤❤❤❤

[kishortala]

Great video Glenn. Very helpful tutorial. Cheers to Chorizo ❤

[DB-sfhy]

Another idea: How to make SSMS start up faster on corporate workstation? Sometimes it takes me several minutes to start up SSMS. I noticed your SSMS was ready immediately

[pankaj]

Pls make video on HA server patching .

[fabioantonioberti]

Thanks for the video. I have a question, for an environment that has a Cluster of 2 VMs with Always ON, what care should I take when patching? Which VM is recommended to start, primary or secondary? If I start with the primary, should I force manual failover to the secondary VM?

[sackos]

Great video! Can I install CU on top of GDR build?

[RadekGaska]

Hello Glenn, Could you please advise rollback plan for patching? Is it necessary to take VM's snapshots, SQL backups etc or it does not make any sense for patching activities?