Do you need sql server 2014 SP 1 and the latest CU or can you just download the latest CU?

Question

Do you need sql server 2014 SP 1 and the latest CU or can you just download the latest CU?

JP10

SSCarpal Tunnel

Points: 4372
More actions
May 31, 2016 at 3:50 pm

#310916

I have sql 2014 RTM need to upgrade it to latest and greatest. So can I just download the latest cumulative update or do I need SP 1 AND then the latest cumulative update? Appreciate it.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Igor Micev SSC-Dedicated Points: 33109 More actions · Answer 1

You can just download the latest CU and upgrade with it.

https://blogs.msdn.microsoft.com/sqlreleaseservices/announcing-updates-to-the-sql-server-incremental-servicing-model-ism/

Igor Micev,My blog: www.igormicev.com

Phil Parkin SSC Guru Points: 246965 More actions · Answer 2

Igor Micev (5/31/2016)
You can just download the latest CU and upgrade with it.
https://blogs.msdn.microsoft.com/sqlreleaseservices/announcing-updates-to-the-sql-server-incremental-servicing-model-ism/

Are you sure? The following text appears on the CU5 page:

"This article describes cumulative update package 5 (Build number: 12.0.4439.1) for Microsoft SQL Server 2014 Service Pack 1 (SP1)."

Notice how SP1 is mentioned explicitly, as if it is a pre req for the CU.

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

JP10 SSCarpal Tunnel Points: 4372 More actions · Answer 3

So which one is it? =) I think I will go down the SP 1 first then the cu route. It doesn't hurt I guess to go down the old traditional route. Appreciate the help guys.