January 13, 2011 at 11:23 am
All -
I'm trying to find some documentation or any type of information regarding upgrading a 2008 cluster to 2008 R2 - SQL Upgrage only. I've been looking and haven't found much of anything out there. I have an active/active cluster and I'm not sure if I need to fail everything over to one node and perform the upgrades from there. Any information would be greatly appreciated.
January 23, 2011 at 6:29 pm
From what I've read, you should be able to move both instances over to node A, successfully run the upgrade on the passive node, now node B, and then fail over the instances into SQL Server 2008 R2. Once you failover, you have no failback option. However, once failed over, you can then proceed with upgrading node A to 2008 R2. Once that is complete, I would test the failover of both instances back to node A, and then if you want to return to running them on separate nodes, you can do so knowing that failovers and failbacks are successful.
Unfortunately, I haven't done this myself to validate those steps, but you should treat that upgrade as you would treat the upgrade from SQL 2005 to 2008, as once you go up, you can't go back.
Hope that information helps,
Steve
February 8, 2011 at 8:13 am
S.K. is exactly right.
One thing to watch out for, for some reason, every time I've done the upgrade, the upgraded node becomes deselected in the "Possible Owners" Advanced Policy for the Server Name item in the SQL Server entry under Services and Applications. It won't let you fail back until you go back in and readd the node as a Possible Owner.
July 12, 2011 at 2:28 pm
Excellent info gentlemen! I've been researching this issue myself.
Have any of you experienced difficulties with the DTC or other cluster services becoming unavailable?
Thanks a lot
July 12, 2011 at 3:45 pm
I have not personally seen any issues with the DTC. I will say, however, that we have the DTC running as its own service in the cluster, and don't have it as part of the SQL group.
To be safe, if you have the DTC name, IP, and service all in the same SQL application in the cluster, I might separate out them into their own service so the SQL installer doesn't get "confused".
However, I believe it is an MS recommendation to pair the DTC with the SQL application post-win 2003, but we haven't moved away from that model of keeping them separate (kind of a "don't fix it if it's not broken mentality").
Cheers,
Steve
August 12, 2015 at 12:05 pm
Hi All,
I have done on 1st passive node successfully and when i doing on 2nd passive node (mean move passive as active) struckup in on REPORT SERVER AUTHENTICATION option.
In that i found 2 options one is windows auth and 2nd is Mixed mode. I have tried both but not accessing any password.
Could you suggest me on this..
August 13, 2015 at 5:27 am
AndeT (1/13/2011)
All -I'm trying to find some documentation or any type of information regarding upgrading a 2008 cluster to 2008 R2 - SQL Upgrage only. I've been looking and haven't found much of anything out there. I have an active/active cluster and I'm not sure if I need to fail everything over to one node and perform the upgrades from there. Any information would be greatly appreciated.
Much the same as any upgrade or patch in sql server, you apply the upgrade to the passive nodes first, once complete you failover the instances to the passive nodes which then upgrade to 2008 R2. You then upgrade the original node which is now passive
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply