So, it's been a while since the discussions about patching changes to SQL Server by Microsoft in these links (WSUS for SQL server patching & https://www.brentozar.com/archive/2016/08/windows-update-now-delivers-sql-server-cumulative-updates/#respond) ... I wondering if anyone has any more insight to using WSUS to patch our companies SQL Servers using this approach ... Anyone using WSUS successfully to patch SQL Server 2012 and beyond? It seems like this is the direction that Microsoft is heading ... If we were to do this (and we have tested a couple of servers), it would be to enable the SQL Server patches along with the Windows patches. Any thoughts?
I know this is an older question but I was recently looking for some new information about using WSUS for patching SQL Servers and came across this one.
I used to use WSUS at an old job for patching SQL Server instances but we only used it for managing the various non-prod and prod server groups, manually selecting the desired SPs and/or CUs to be applied after a version review, and ultimately pushing the patch software to the servers.
For all of the reasons noted in other posts (Cluster/AOAG failovers, running maintenance jobs, replication, etc.) we managed the actual patch installation manually. This was not perfect but it did save our team a ton of time since we had over 200 servers with varying versions of SQL server to patch. Sadly, it does not look like Microsoft has made progress in using WSUS for patching SQL Server instances, but if you are looking to save time it might be worth a try. Just proceed with caution and pay attention to the WSUS options to ensure you are only selecting the "Download Only" option.