Breaking a Sql Cluster

Giganews Newsgroups
Subject: Breaking a Sql Cluster
Posted by:  David (Dav…@discussions.microsoft.com)
Date: Mon, 3 Mar 2008

We have an Active/Active/Passive SQL 2000 cluster and budgetary constraints
have made it impossible for us to upgrade the hardware to new servers. Our
current servers are capable of handling the upgrade but some of our databases
might not be compatible with SQL 2005.  Can we evict the passive node, make
it a standalone, upgrade it and then migrate the databases to the new server
without killing the cluster? Will the cluster run if the passive node is
evicted?

Replies