When did you last time patch your SQL Server? I often discuss this question with my clients, I get many different kinds of answers.
SQL SERVER – Service Pack Failure: MissingRegistryKeyException. The Registry Key is Missing
A reader hit MissingRegistryKeyException during a service pack, but my earlier fix did not help. Here is another cause of the missing registry key and the fix.
SQL SERVER – Service Pack Error – Index (Zero Based) Must be Greater Than or Equal to Zero and Less Than the Size of the Argument List
A service pack failed with: Index (zero based) must be greater than or equal to zero and less than the size of the argument list. Here is what I found.
SQL SERVER – Service Pack Error – Attributes do not Match
A service pack error on my lab machine: ‘Attributes do not match’, with the folder shown as Compressed. Here is what Summary.txt said and the fix.
SQL SERVER – Unable to Install Service Pack in Cluster – There was an Error to Lookup Cluster Resource Types
A service pack install in a cluster failed with: There was an error to lookup cluster resource types. Detail.txt pointed to the cause. Here is the fix.
SQL SERVER – CREATE OR ALTER Supported in Service Pack 1 of SQL Server 2016
SQL Server 2016 Service Pack 1 introduced CREATE OR ALTER. I use it for repeatable deployments of supported object types.
SQL SERVER – Setup Screen Not Launching While Updating a Patch
Double clicking a SQL Server patch just flashed a window and vanished. SqlSetup.log in the %temp% folder showed why the Setup Screen was not launching.