SQL Server 2008 cluster upgrade

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » SQL Server 2008 cluster upgrade

SQL Server 2008 cluster upgrade

Rate Topic

Display Mode

Topic Options

Author

Message

Raghavender

Posted Monday, February 18, 2013 3:37 AM

Right there with Babe

Group: General Forum Members
Last Login: Today @ 4:39 AM
Points: 722, Visits: 843

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

Perry Whittle

Posted Monday, February 18, 2013 9:07 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 10:11 AM
Points: 5,242, Visits: 11,262

What operating system is the cluster using Windows 2003 or Windows 2008?

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

"Ya can't make an omelette without breaking just a few eggs" Wink

Post #1421256

Raghavender

Posted Monday, February 18, 2013 7:43 PM

Right there with Babe

Group: General Forum Members
Last Login: Today @ 4:39 AM
Points: 722, Visits: 843

Windows 2008

Thanks and Regards!!

Raghavender Chavva

Post #1421408

Want a cool Sig

Posted Monday, February 18, 2013 10:51 PM

SSC Veteran

Group: General Forum Members
Last Login: Thursday, June 13, 2013 11:20 AM
Points: 225, Visits: 462

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.. Tongue

Generally speaking of course...

---------------------------------------------------------------
Mike Hahn - Future MCM 2025 Smile

Right way to ask for help!!
http://www.sqlservercentral.com/articles/Best+Practices/61537/
I post so I can see my avatar Hehe

I want a personal webpage Cool

I want to win the lotto BigGrin

I want a gf like Tiffa w00t

Post #1421436

nicbyte

Posted Tuesday, February 19, 2013 12:13 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, June 14, 2013 4:28 AM
Points: 6, Visits: 38

Just Fail your active resources over to your passive node and upgrade that instance. then Fail back and upgrade your passive node.

Post #1421449

Raghavender

Posted Wednesday, February 20, 2013 9:43 AM

Right there with Babe

Group: General Forum Members
Last Login: Today @ 4:39 AM
Points: 722, Visits: 843

if anybody has the document, can you please provide me ?

Thanks and Regards!!

Raghavender Chavva

Post #1422158

« Prev Topic | Next Topic »

Permissions