Clustered SQL Server Instances Do Not Appear To Update When Patching With Protect

Version 5

    Symptoms

     

    When attempting to patch clustered SQL Servers with Protect you see that updates never apply or do not appear to update SQL.

     

    Cause

     

    Currently, Protect does not natively provide a solution to deploy patches to SQL servers in clustered configurations. Patching SQL clusters with Protect is unsupported. However, with manual intervention Protect can be used to both assess and deploy patches to SQL servers in a cluster.

     

    Resolution

     

    If you wish to patch clustered instances of SQL, we recommend you break the cluster and apply patches individually, then re-join the cluster. This is currently the only known method or workaround to properly update clustered SQL servers with Protect.

    Please refer to the following Microsoft Document SQL Server failover cluster rolling patch and service pack process to ensure succesful patching of Microsoft SQL Server.

     

    Additional Information

     

    More information about SQL Server failover clustering can be found in a Microsoft article, here.

    If you would like to submit a feature/change request for Shavlik Protect, you can do so here.

     

    Affected Product(s)

     

    Shavlik Protect 9.x