Cluster Rolling upgrade question for SQL Server 2005 Standard Edition -- sql server clustering

frankm
8/24/2007 1:31:27 PM

We have traditionally used a rolling upgrade method for moving to new
hardware on a MS cluster.
We would add one new node tp an existing 2 node cluster and install SQL
Server to the new node.
Once we get the new hardare all installed, we wpould uninstall SQL Server
from the original nodes and evict the nodes.

The question is...
1) With SQL Server 2005 only supporting a 2 node cluster configuration,
are we stuck at the original 2 nodes and having to build a new cluster to
upgrade to.
OR.............
2) Would we need to uninstall SQL Server from one of the old nodes and
then to a new node one at a time?
OR.............
3) Is there a facility that would allow us to have at least 3 nodes in a
SQL Server 2005 cluster for a rolling upgrade.

I am guessing that it would be #2, but I have to ask.

frankm

Geoff N. Hiten
8/24/2007 2:40:15 PM

SQL 2005 Standard Edition only installs on clusters with 2 or fewer nodes.
So, you would need to drop down to a single-node cluster and then add the
new node in.

And the answer to #3 is "Enterprise Edition".

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server clustering

sql server clustering : Cluster Rolling upgrade question for SQL Server 2005 Standard Edition