August 22, 2014 at 4:24 am
we would like to perform this upgrade from our sql servers 2008 r2 on latest 2014, are there any recommendations, specific prerequisites or other information you consider relevant from your experience that you'll like to share?
August 22, 2014 at 5:04 am
Which Windows operating system are you currently using and which edition of sql server 2008 R2?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 22, 2014 at 7:09 am
Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) Apr 2 2010 15:48:46 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)
August 22, 2014 at 9:02 am
The only real gotcha i've noticed when going from SQL server 2008 to SQL server 2012 or higher is the identity\sequence issue. If you have columns that use an identity value, these values jump upon a sql server restart. Now while it shouldnt really be an issue, it has upset some people 😀
There is a trace flag to force the legacy (sql 2008 and lower) behaviour.
Apart from that, do you plan to upgrade the OS too? Upgrading the cluster is feasible if you just want to upgrade the sql server version but moving to new hardware and OS as part of the upgrade should be considered.
What is the state of your current hardware, how much service life does it have left?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply