Sql-server – Apply the latest Service Pack and Cumulative Update

patchingservice-packsql serverupdate

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?

Best Answer

When patching SQL Server:

  1. Apply the most recent Service Pack, then
  2. 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.