Tips for Upgrading a Cluster to SQL 2008

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Alejandro Pelc » Tips for Upgrading a Cluster to SQL 2008 -...

Tips for Upgrading a Cluster to SQL 2008 - Part 2

Rate Topic

Display Mode

Topic Options

Author

Message

Ale Pelc

Posted Monday, March 19, 2012 10:08 PM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, April 18, 2013 1:17 PM
Points: 1,109, Visits: 522

Comments posted to this topic are about the item Tips for Upgrading a Cluster to SQL 2008 - Part 2

Alejandro Pelc

Post #1269332

Alex Friedman

Posted Tuesday, March 20, 2012 1:48 AM

Grasshopper

Group: General Forum Members
Last Login: Thursday, May 09, 2013 9:11 AM
Points: 10, Visits: 171

In this case, the only difference is that after performing the upgrade, the setup process automatically fails over the resources to another node.

Doesn't the setup automatically fail over the resources before the upgrade?

That was the case on my environment, so if that’s the case on yours too it’s time to install the service pack for SQL 2008.

It's a good idea to slipstream the SPs into the main installation, so that you don't need to install them separately.

Post #1269381

Megistal

Posted Tuesday, March 20, 2012 6:12 AM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 8:29 AM
Points: 1,243, Visits: 1,774

Wouldn't have been quicker to slipstream the service pack and performing both the upgrade and the service pack at the same time?

http://blogs.msdn.com/b/petersad/archive/2009/02/25/sql-server-2008-creating-a-merged-slisptream-drop.aspx

Post #1269474

Ale Pelc

Posted Tuesday, March 20, 2012 7:04 AM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, April 18, 2013 1:17 PM
Points: 1,109, Visits: 522

That is completely true, it would have been quicker if I slipstream the service pack into the installation files. I didn't face it that way because not all companies follow the same patch level rules and procedures, so I wanted to separate the process into Upgrade and the Update.

Thanks,
Alejandro

Alejandro Pelc

Post #1269516

Aldo Gonzalez

Posted Tuesday, March 20, 2012 9:01 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, May 10, 2013 12:23 PM
Points: 8, Visits: 154

Thank you for sharing Alejandro.

Post #1269628

eric.lyons

Posted Wednesday, March 21, 2012 7:32 AM

Valued Member

Group: General Forum Members
Last Login: Friday, September 07, 2012 8:27 AM
Points: 68, Visits: 284

You completed with:
At this point, all passive nodes has the service pack installed and it’s time to perform the update on the active node (serverA), so connect to it and perform the installation of the service pack. The process won’t be different at all as the one on the other nodes as we’ll update one instance at the time. Once the three instances were updated, the SQL Instances 1, 2 and 3 are at the same patch level on all nodes.

Question:
Did you fail over to another server first before upgrading the final server?

*****

Give a man a fish, and you've given him a meal. Teach a man to fish and he'll ask to borrow your boat. Tongue

Post #1270154

Ale Pelc

Posted Wednesday, March 21, 2012 7:43 AM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, April 18, 2013 1:17 PM
Points: 1,109, Visits: 522

Hi Eric,
No, I didn't fail over the resources on the last server. That will be handled by the service pack installation process as it will failover automatically the instances, so there's no need to do it manually.

Regards,
Alejandro

Alejandro Pelc

Post #1270163

« Prev Topic | Next Topic »

Permissions