SQL Server 2012 - Quickest way to get up to the latest update

  • We have a Windows Server 2008 R2 machine that is running SQL 2012 (SP1) - 11.0.3128   Dec 28, 2012

    What is the recommended (easiest?)  way to apply all the remaining patchs to get up to the latest version?  

    Thank you

  • First you should find out what the latest Service Pack is.   (I think it's SP3) and then download that and install it.   That will bring you to the level associated with the Service Pack.   Not everyone needs to get every CU (cumulative update), so that's usually an organizational choice, so if you need those, then you go find the latest CU for that Service Pack level and install it, and then assuming you got the latest SP, and the latest CU, you're as up to date as you can get.   Don't forget to test the installation in some kind of test environment...

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)

  • sgmunson - Friday, April 14, 2017 10:14 AM

    Don't forget to test the installation in some kind of test environment...

    +100

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • 2012 had some pretty nasty problems over its lifetime.  As a result, we keep it up to date on every CU (not something I've done on previous versions).  For you, I'd install SP3 and then install the latest CU for SP3.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

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

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