Windows Updates and SQL Server CU's, If you install Automatically How do you do it?

J

Jason Spatz

Good Morning!

So our System Admins have setup OU's that have windows updates pushed once a month, so for example, there is a folder 1st Tuesday 6am, and at 6am it installs all patches that have been approved. (dev servers get them on the 3rd tuesday of the month, to catch all new security patches from patch tuesday before they are applied in production) However with SQL Server CU's we are noticing that they will not install if the flag is set that states the server needs to reboot. And it seems OS updates always apply first and proceed to set the flag, so the SQL CU's are failing pretty much every month that an OS patch sets that flag. Then the next month comes, there are more OS patches which apply first and again set that reg entry and again the SQL Server CU from the previous month (or the one that replaced it) fails again. System admins say there isn't much they can do about that, so we are just curious how other organizations handle this kind of process, and they also told us SQL Server CU's can not be excluded as the "CU" class encompasses all microsoft products. Any input is appreciated!


Thanks

Jay

Continue reading...
 
Back
Top Bottom