patternsqlModerate
Apply the latest Service Pack and Cumulative Update
Viewed 0 times
thelatestupdateapplycumulativepackserviceand
Problem
I have given an RTM version of SQL Server 2014 and I need to apply the latest SP (currently SP2) and CU (currently CU8). Do I need to apply SP1 first? Or can I straight move to SQL Server 2014 SP2 CU8 without applying the old Service Pack 1 and the related Cumulative updates?
Solution
When patching SQL Server:
You never have to go through Service Packs or Cumulative Updates in order. Just use the most recent of each, in the order above.
- Apply the most recent Service Pack, then
- Apply the most recent Cumulative Update for that Service Pack.
You never have to go through Service Packs or Cumulative Updates in order. Just use the most recent of each, in the order above.
Context
StackExchange Database Administrators Q#191419, answer score: 13
Revisions (0)
No revisions yet.