• The SP installer can update the clustered components on all nodes, plus the non-clustered components on the node on which it is run, all within a single run of the SP installer.

    However, I do not think it updates the non-clustered components on nodes that it is not run on. You should therefore plan on running the SP installer on all the nodes that you have SQL Server installed on, to make sure that all non-clustered components are updated.

    Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

    When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara