If I apply Cumulative Update 3 in SQL Server 2012 SP1, do I still have to do Cumulative update 1 and 2 before I can apply CU 3? And also, how would you know what CU's or hot fixes that has already been applied in SQL Server?

  • 1
    Cumulative updates are cumulative, so no, you don't have to apply previous ones. But more importantly, why are you on unsupported SP1 instead of SP3? – Aaron Bertrand Apr 21 '16 at 5:04
  • @AaronBertrand Thats just an example, but thanks for letting me know. Didnt know SP1 is unsupported. How can you check what CU's or hot fixes have already been installed on the instance? – Keith Rivera Apr 21 '16 at 5:18
  • 1
    You check SERVERPROPERTY('ProductVersion') against a known list of builds. There are multiple places online for this, IMHO start here. – Aaron Bertrand Apr 21 '16 at 12:40

No. Each CU contains all the fixes in the CUs prior to it.

For the second part of the question, the only RELIABLE way supported across most versions (2005+) is to get a 4 part number and compare it to any of the comprehensive build lists available on the internet:

Select Serverproperty('ProductVersion') 

You can also check @@Version but it's not reliable, as some older CUs don't list their CU number as they were meant to. You can also try Serverproperty('ProductUpdateLevel') but it's only supported on a few newer versions and service packs of SQL Server.

So I stick with build numbers. Most DBAs have one script or another to pull data from web sources into a table to do translations.

If in doubt start the CU installer and it will check whether it's needed or not. It won't let you continue upgrading if you've already upgraded everything on the server.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.