Post reply

Question about service packs

  • April 10, 2018 at 1:51 pm

    #403240

    Hi,

     I have SQL server 2012, which I am not sure if this maters, but it is sitting on a machine using Win10 pro.
    Anyway, the last service pack it had I s SP2. SO I am wondering if I can just get SP 4 or do I have to get 3 first. 
    Also this is a small company and we only have one server. Trying to change that, but right now we only have the one that is our Dev and Prod.
    s there aanything I need to know be fore installing this

    Thank you

  • April 10, 2018 at 4:03 pm

    #1986232

    itmasterw 60042 - Tuesday, April 10, 2018 1:51 PM

    Hi,

     I have SQL server 2012, which I am not sure if this maters, but it is sitting on a machine using Win10 pro.
    Anyway, the last service pack it had I s SP2. SO I am wondering if I can just get SP 4 or do I have to get 3 first. 
    Also this is a small company and we only have one server. Trying to change that, but right now we only have the one that is our Dev and Prod.
    s there aanything I need to know be fore installing this

    Thank you

    You can do just SP4 - the service packs contain the fixes from previous service packs. They are cumulative.
    To be safe in your situation, backup the databases and create a restore point before installing.

    Sue

  • April 10, 2018 at 5:01 pm

    #1986235

    Thank you that sounds like good advice

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

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