0

We were running on SQL Server 2016 Standard Edition 2016 SP2-CU4 on our ALWAYS-ON HA cluster.

Due to some recent issues one of our nodes got corrupted and we had to replace it with a new node. Since this was a fresh image from AWS Marketplace it came with SP2-CU13 (latest) out of the box.

The client wants this to be rolled-back to the original SP2-CU4 (no plans/requirement of upgrading to CU13).

As a primary step I tried to install the SP2-CU4 KB article on the instance but that does not work with the attached error message. (No SQL Server instance or feature can be updated on this computer)

enter image description here

Q1 - How can SP2-CU4 installed on the server.

Q2 - What is the impact if the cluster runs on different CU's.

Improve this question
2
  • Unless I was experiencing a known bug, I would not go backwards to lower CUs on a system under any circumstances.
    – LowlyDBA - John M
    Commented Jul 26, 2020 at 15:45
  • @LowlyDBA That sounds about right, but just in case if that happens. What could be the plan of action.
    – Mrigank
    Commented Jul 27, 2020 at 12:23

1 Answer 1

Reset to default
1

You said you are running a new instance of SQL 2016 SP2 CU13. In order to install CU4, you will need to uninstall later CUs. I just spun up a new EC2 instance with SQL 2016 STD and went to Control Panel > Programs > Programs and Features > Installed Updates and saw Hotfix 5820, 5698, and 5598 after SP2. They should be uninstalled in the order listed from the newest to the oldest. After that you will be on SP2 and you can install SP4.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.