Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Tuesday, November 4, 2014 2:31 AM
Points: 748, Visits: 906
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


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 3:41 PM
Points: 6,760, Visits: 14,413
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
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Tuesday, November 4, 2014 2:31 AM
Points: 748, Visits: 906
Windows 2008

Thanks and Regards!!

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


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, April 24, 2014 9:12 AM
Points: 285, Visits: 504
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 - Future MCM 2025
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
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
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Tuesday, November 4, 2014 2:31 AM
Points: 748, Visits: 906
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