Post reply

Is it OK to leap-frog service packs to get to SQL 2012 SP4?

  • August 8, 2018 at 8:35 am

    #357497

    Hello experts,

    I've read that SQL Server service packs are totally cumulative, but we have a dev SQL 2012 server that is pre-SP1. Is it still possible to go straight to SP4 in cases like that (pre-SP1, SP1, SP2), or is it safer to install the service packs in rapid succession to keep things sequential in case the installation goes sideways?

    Thanks for any help!
    - webrunner

    -------------------
    A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
    Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

  • August 8, 2018 at 8:47 am

    #2000827

    You will be fine to go straight to SP4, as you say the service packs are cumulative.

    Thanks

  • August 8, 2018 at 9:20 am

    #2000850

    In this case, that's true but SPs haven't always been that way.  Take 2005, for example.  In order to update RTM to SP2, you first had to update RTM to SP1.  Always read the documentation for any given SP or CU to ensure there are no non-cumulative or other special requirements.

    --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)

  • August 8, 2018 at 10:02 am

    #2000866

    Thanks, NorthernSoul, Jeff,
    I'll review the documentation and see how things go in testing.

    Thanks again.
    -webrunner

    -------------------
    A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
    Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

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

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