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?
Sql-server – Apply the latest Service Pack and Cumulative Update
patchingservice-packsql serverupdate
Related Question
- Sql-server – Service pack and cumulative update
- Sql-server – Apply SQLServer Service Pack to a Single Node Cluster
- Sql-server – SQL Server Service Pack Questions
- Sql-server – Do I really Need to Upgrade to SQL Server 2014 SP2 ? –
- Sql-server – when applying a sql server cumulative update or service pack on a virtual machine – what could be a safe way of stopping VMWaretools
- Sql-server – apply a CU for SP2 that was released after the release of SP3
Best Answer
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.