Any tools to automate SQL Server patching?

I've been looking for a tool or scripts that can automate SQL Server patching of standalone, clusters, mirrors, and always-on systems. Does anyone have something that they are using successfully today? Or, recommendations ... For example, WSUS, RockSolid, BMC Database Automation, SolarWinds Patch Manager, etc. THANK YOU!

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Usman Butt commented · Feb 16, 2018 at 07:04 PM

Very interesting indeed. Would love to see what others say. But we are using a semi-automatic and manual patching model depending upon the complexity and criticality of the environments. We are planning to move to the Cloud, where patching is a different story altogether. So, I do not feel that I qualify for the answer. With this comment I have subscribed to this question though. :) Last but not least, the following blogs by Kendra Little are very helpful. [Should I Automate my Windows Updates for SQL Server?][1] [Required Testing for Installing SQL Server Cumulative Updates and Service Packs][2] [1]: https://littlekendra.com/2016/07/28/should-i-automate-my-windows-updates-for-sql-server-dear-sql-dba-episode-10/ [2]: http://littlekendra.com/2016/04/28/required-testing-for-installing-sql-server-cumulative-updates-and-service-packs/

0 ·