SQL Server 2014 SP1 CU6 to SP2 CU2 latest

Question

Dear All DB Admin,

Currently we are using SQL 2014 Enterprise SP1 CU6 version of 12.0.4449.0 it's working well there is no issues but we would like to update from this SP1 to Sp2 ( Cu2 12.0.5522.0) latest version .. Please let we know what are the procedure are we want to followup 

Note: One of the node We have SQL Fail over & Fail back Cluster 

I am waiting for your valuable feedback

Thanks

Subash

 

Answer 1

Hello Subash,

Install first Service pack 2 for SQL Server 2014: Microsoft® SQL Server® 2014 Service Pack 2 (SP2)  and then the latest CU for it

---

Olaf Helper

[ Blog] [ Xing] [ MVP]

Answer 2

Dear Olaf,

Thanks for your mail and I have a small doubt can i install SP2 directly from SP1 or can i move cumulative update SP1 to one by one ? 

I am waiting for your valuable feedback

Thanks