I am patching a SQL2008R2 Express Edition instance. On the first failed attempt, all seemed to be fine - SQL loaded, dbs online, @@VERSION returned the expected results, but errors were found during installation.
I had the issue below
The registry key System\CurrentControlSet\Services\MSSQLSERVER\Performance is missing.
For which I followed this post to fix
It seems to have worked. I ran Repair from the setup image. But I am not able to run the patch - the initial screen tells me that the Upgrade Status is 'Installed' - whereas before this Repair fix it told me 'Installation incomplete'.
Can anyone confirm that the patching has been successful? I would think so, as it says there SP3, Installed. @@VERSION returns the correct results, but it already did when the patch was 'incomplete'. Has SQL 'caught up' during the repair, or were the incorrectly installed aspects of SP3 repaired?