June 2, 2018 at 4:42 pm
Hi,
I'm running SQL Server 2016 SP1 (specifically SP1-CU4) Developer on my development machine. I had downloaded the full SQL Server 2016 SP2 Developer ISO recently to put on another development machine. I thought, "hey, I wonder if I can run this setup on my machine to upgrade it to SP2" so I wouldn't need to download SP2 separately. It's not really a version upgrade (or edition upgrade), so I wasn't really sure what to expect. So I tried it. Turns out, I'm still at SP1-CU4.
I'm going to download SP2 separately and upgrade my instance, but I'm just wondering--is what happened when I ran the full install (having selected "Upgrade from a Previous Version of SQL Server") what you'd expect? Is there another way that you know to run it that would've brought my instance up to SP2. I've just never tried to upgrade from one SP to another on the same version/edition using a full install...
Thanks in advance,
Mike
Mike Scalise, PMP
https://www.michaelscalise.com
June 2, 2018 at 6:04 pm
I'm not entirely sure what your question is here. The only thing you ask is (and I'm paraphrasing) "Is what happened what you expected to happen?". Well, you said you installed a new instance of SQL server using the SP2 ISO, and it installed that version; so yes, that what I would expect.
I'm pretty sure that isn't what you're asking here though.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 3, 2018 at 6:25 am
Hi Thom,
Thanks for the response. I think you may have misunderstood what I was asking (which is fair because I gave some context to the situation that likely created confusion).
Well, you said you installed a new instance of SQL server using the SP2 ISO, and it installed that version
I actually didn't say that. I said that I ran the full SQL Server 2016 SP2 setup and selected the "Upgrade from a previous version of SQL Server" option in hopes that it would bring my SP1 instance up to SP2. Ultimately it didn't and my instance was still at SP1.
The only thing you ask is (and I'm paraphrasing) "Is what happened what you expected to happen?"
I actually asked two questions--whether it makes sense that the full SQL Server 2016 SP2 install wouldn't upgrade my SP1 instance to SP2. I just didn't know one way or the other.
and
If you wouldn't expect a full install to perform a Service Pack upgrade on an existing instance of the same version/edition by default, then is there a way (through some option or something I'm missing) to run it that would upgrade my instance to SP2?
I don't know if that clears anything up....I ended up downloading just the SP2 upgrade and installing it, which went fine--though it would've been cool to save myself a download if I knew I could've done it with the full install.
Thanks,
Mike
Mike Scalise, PMP
https://www.michaelscalise.com
June 4, 2018 at 2:03 am
SP1 to SP2 isn't an upgrade though, it's a patch.
June 4, 2018 at 5:23 am
Beatrix Kiddo - Monday, June 4, 2018 2:03 AMSP1 to SP2 isn't an upgrade though, it's a patch.
Ok, so then my two questions are:
1) Does it make sense that the full SQL Server 2016 SP2 install file wouldn't patch my SP1 instance of the same version/edition to SP2?
2) If you wouldn't expect the full install file to patch a SP1 instance of the same version/edition to SP2 by default, then is there a way (through some option or something I'm missing) to run it that would patch my instance to SP2?
I guess yet another way to say it is:
I know the SQL Server 2016 SP2 installation wizard has many options to get you to that version/level like installing a new instance, upgrading from a previous version, upgrading from a previous edition. Does it also have a way to "upgrade from a previous patch level" (i.e., SP1 to SP2)? If it has all of these other options in one wizard to bring you current, then why not this too?
Thanks,
Mike
Mike Scalise, PMP
https://www.michaelscalise.com
June 4, 2018 at 5:52 am
Ahh, I see the confusion now. Upgrade means that you want to upgrade (for lack of better word) the version of SQL Server you have. So, if you have SQL Server 2008 - SQL Server 2014 then you would upgrade it to 2016.
As Sue pointed out, installing SP2 on an instance using SP1 isn't an upgrade; it's a patch. You can't upgrade SQL Server 2016 to SQL Server 2016, it's already 2016. Thus an "upgrade" process wouldn't work, as there's nothing to upgrade.
if you want to install SP2, then you need to download the SP2 KB file: https://cloudblogs.microsoft.com/sqlserver/2018/04/24/sql-server-2016-service-pack-2-is-now-available/
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 4, 2018 at 6:22 am
Mike Scalise - Monday, June 4, 2018 5:23 AMBeatrix Kiddo - Monday, June 4, 2018 2:03 AMSP1 to SP2 isn't an upgrade though, it's a patch.Ok, so then my two questions are:
1) Does it make sense that the full SQL Server 2016 SP2 install file wouldn't patch my SP1 instance of the same version/edition to SP2?
2) If you wouldn't expect the full install file to patch a SP1 instance of the same version/edition to SP2 by default, then is there a way (through some option or something I'm missing) to run it that would patch my instance to SP2?
I guess yet another way to say it is:
I know the SQL Server 2016 SP2 installation wizard has many options to get you to that version/level like installing a new instance, upgrading from a previous version, upgrading from a previous edition. Does it also have a way to "upgrade from a previous patch level" (i.e., SP1 to SP2)? If it has all of these other options in one wizard to bring you current, then why not this too?
Thanks,
Mike
Yes, I would not expect a full install to patch an existing instance.
Thom, it's an honour to be confused with Sue_H :).
June 4, 2018 at 6:54 am
Beatrix Kiddo - Monday, June 4, 2018 6:22 AMYes, I would not expect a full install to patch an existing instance.Thom, it's an honour to be confused with Sue_H :).
Ha! I have no idea how I managed that. I must have just read another of her posts and had her on the brain (that could be read wrong).
No offence intended either way though. 🙂
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 4, 2018 at 2:34 pm
Beatrix Kiddo - Monday, June 4, 2018 6:22 AMYes, I would not expect a full install to patch an existing instance.Thom, it's an honour to be confused with Sue_H :).
You need more coffee. A lot more.
But in Thom's defense - we do look alike. Compare our avatars. 🙂
Sue
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply