September 3, 2014 at 12:28 pm
I have a sql 2008 log shipping solution which will be changed to always on soon. It is sql2008r2 on windows 2012. Should a simple upgrade of the sql server to 2012 work on this box before adding it to the solution, or is it really necessary to remove and the install 2012?
September 4, 2014 at 5:41 am
an upgrade is perfectly viable as long as it's between supported editions. What is the state of each node for cluster membership? Is the current instance a Failover Cluster Iinstance of sql server?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 4, 2014 at 6:43 am
should have elaborated plan is
have a win2008/sql2008r cluster log ships to a stand alone 2012/sql2008r2 server.
Plan on killing log shipping upgrade win2012/sql2008r2 box to win2012/sql2012
Take one node out of win2008/sql2008r2 cluster, blow box away, make win2012/sql2012 cluster
Move databases to new cluster.
Kill remaining win2008 node, rebuild as 2012 and add node to new cluster.
Create always on.
All nodes will be sql enterprise edition
September 4, 2014 at 7:08 am
do you want the AlwaysOn solution to reatin a failover cluster instance as a replica? There are restrictions by doing this 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 4, 2014 at 7:24 am
the cluster is a standard active/passive cluster, the other node will actually be used for reporting. Forgot to mention will add a stand alone win2012/sql2012 machine for DR
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply