Do any guidelines exist?
Situation: Active passive 2 node cluster using SAN drive.

For starters I'm thinking:
1. back up all SQL databases located on shared SAN drive.
2. uninstall clustered sql.
3. uninstall clustering
4. re-install clustering with node 1, new node 2
5. re-install clustered sql, establishing virtual sql
instance on SAN drive
6. restore sql databases.

Any advice?
Is it possible to not uninstall clustering, but to install
clustering on the new node and add it to the existing
cluster?
Thanks!

You forgot to mention which version of SQL yoyu are using. SQL 7 and SQL
200 clusters are very different beasts.

--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com

I support the Professional Association for SQL Server
www.sqlpass.org

"Michael Trantow" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Sorry Geoff, my bad...installed version is SQL Server 2000
Enterprise Edition, at SP3a. Windows Advanced Server OS
is at SP4, with all critical updates applied.

See "Maintaining a Failover Cluster" in SQL Server Books
Online.
HTH

Bjorn

If you have an edition of Windows that allows more than 2 nodes, you can
add the new node first before removing the old one.

To remove a node, you have to first run SQL setup (see BOL on how to remove
a node) to "evict" the node at the SQL level for each SQL instance
installed. Then evict the node at the Windows level. Add the new or rebuilt
node back at the Windows level, then run SQL setup for each instance to add
the node back as a possible owner of that instance. Adding it as a
node/possible owner puts the RTM version of the SQL Server files on the new
node. Then apply the service pack/hotfixes to get the newly added node to
the same level as the existing node(s).

Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.