July 24, 2015 at 3:40 am
Hi
I have a 2 node cluster in my production environment. The cluster is SQL 2008 R2 enterprise edition and setup as active\active with a maximum of 12 instances on it. I'm planning to upgrade the cluster to SQL 2014 enterprise for all the 12 instances that are running on the cluster. Now I need to know if I can do a straight in place upgrade without having to first upgrade to SQL 2012 and then upgrade to SQL 2014.
July 24, 2015 at 9:58 am
Hi FTdenaliFTdenali.
Yes the direct upgrade path that you desire is possible I believe.
July 26, 2015 at 9:17 am
Thanks
July 26, 2015 at 9:57 am
FTdenali (7/24/2015)
Now I need to know if I can do a straight in place upgrade without having to first upgrade to SQL 2012 and then upgrade to SQL 2014.
What edition of sql server 2008R2 are you currently using and what edition do you plan to upgrade to?
Also, another thing to consider is the current version of the Windows OS, what OS are you currently using?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 27, 2015 at 2:33 am
SQL 2008 R2 enterprise with SP2 and CU.
the current environment is running Windows 2008 R2 enterprise.
One more thing, ALWAYSON availability groups are only available on windows 2012 or can I have the feature on windows 2008 R2 as well?
July 27, 2015 at 2:44 am
July 27, 2015 at 2:48 am
Thanks i'll keep that in mind.
Any thing I should look up for when upgrading the OS to SP1?
does it have any impact on my current SQL 2008 R2 SP2 enterprise?
July 30, 2015 at 4:30 am
FTdenali (7/27/2015)
SQL 2008 R2 enterprise with SP2 and CU.the current environment is running Windows 2008 R2 enterprise.
It would make sense to update the Windows OS platform too as Windows 2008 R2 is already at least 6 years old, something to consider!
FTdenali (7/27/2015)
One more thing, ALWAYSON availability groups are only available on windows 2012 or can I have the feature on windows 2008 R2 as well?
Windows Server 2008 is the minimum requirement for AlwaysOn Availability groups, more may be found at this link
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 30, 2015 at 4:40 am
Thanks, and is it true that upgrading SQL 2008 R2 to SQL 2014 on windows 2008 R2 SP1 can only be done the Slipstream way?
July 30, 2015 at 10:30 am
FTdenali (7/30/2015)
Thanks, and is it true that upgrading SQL 2008 R2 to SQL 2014 on windows 2008 R2 SP1 can only be done the Slipstream way?
No, there is a misunderstanding here.
If the sql server 2014 installer is the original RTM edition you can either create a drop merged install by unpacking the dvd image integrating the SP1 files and then repacking or by running the sql server RTM installer and pointing to the SP1 update files which is a slipstream install.
Nothing to do with Windows OS version
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 31, 2015 at 12:34 am
That part I understand, but can I upgrade sql without using slipstream option if I have SQL 2014 SP1 image?
July 31, 2015 at 5:15 am
FTdenali (7/31/2015)
That part I understand, but can I upgrade sql without using slipstream option if I have SQL 2014 SP1 image?
If you have a sql2014 SP1 dvd image then you wont be slipstreaming
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply