Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server 2008 cluster upgrade Expand / Collapse
Author
Message
Posted Monday, February 18, 2013 3:37 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, December 2, 2016 6:38 AM
Points: 1,024, Visits: 1,196
Hi Team,

We have SQL Server 2008 active-passive cluster. We got requirement to upgrade it SQL Server 2008 R2.

Can you please let me know the procedure ?



Thanks and Regards!!

Raghavender Chavva
Post #1421126
Posted Monday, February 18, 2013 9:07 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 10:39 AM
Points: 8,324, Visits: 16,475
What operating system is the cluster using Windows 2003 or Windows 2008?

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1421256
Posted Monday, February 18, 2013 7:43 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, December 2, 2016 6:38 AM
Points: 1,024, Visits: 1,196
Windows 2008

Thanks and Regards!!

Raghavender Chavva
Post #1421408
Posted Monday, February 18, 2013 10:51 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, December 2, 2016 3:27 PM
Points: 312, Visits: 705
Raghavender (2/18/2013)
Windows 2008

64 or 32 bit (OS, SQL)? Just upgrading SQL Server or hardware/OS upgrades as well?

Personally I'd upgrade 1 instance at a time side by side (Generally)...
1. Setup new 2008 R2 cluster group with a generic server name and the same instance name.
2. Copy all the databases to the new instance.
3. Turn off old cluster group and re-use the IP/name on the new group.
4. Cross fingers and turn new group on with old IP and name.
5. If any issues turn the old one back on.
(assuming there's enough hardware for another cluster group)
I don't like in-place upgrades... too scary..
Generally speaking of course...


---------------------------------------------------------------
Mike Hahn - MCSomething someday
Right way to ask for help!!
http://www.sqlservercentral.com/articles/Best+Practices/61537/
I post so I can see my avatar
I want a personal webpage
I want to win the lotto
I want a gf like Tiffa Oh wait I'm married!
Post #1421436
Posted Tuesday, February 19, 2013 12:13 AM


Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, November 28, 2014 12:36 AM
Points: 6, Visits: 93
Just Fail your active resources over to your passive node and upgrade that instance. then Fail back and upgrade your passive node.
Post #1421449
Posted Wednesday, February 20, 2013 9:43 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, December 2, 2016 6:38 AM
Points: 1,024, Visits: 1,196
if anybody has the document, can you please provide me ?

Thanks and Regards!!

Raghavender Chavva
Post #1422158
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse