following up on the geerhead message:

first, uncluster the SQL then reboot node1
second, upg the sql 7 to sql 2000
third, upg the sql 2k to sql 2000 cluster instance...

OK...are there any upgrades to node2? Or will thw sql 2k
cluster instance take care of that?

The upgrade from a standalone to a clustered instance will apply the RTM
version of the SQL Server files to any nodes listed as possible owners. So
you have to then reapply the latest service pack and any hotfixes (see the
readme for sp3a).

Note that you can only upgrade from standalone to clustered if the binaries
are on the local drives and the data is all on one or more shared drives.

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

So, if I have all the programs and data and the quorum on
a shared drive, this should be ok??

No and No. First, SQL should not share a physical disk resource with teh
quorum drive. This defeats the entire high availability strategy of
clustering. Second, SQL operates on local binaries and shared data.
Binaries (Programs) need to be on local disks. The installer will handle
installing/updating all cluster nodes at once.

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

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

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

The binaries are separated. You can put data on the same drive as the
quorum. It isn't recommended, but it can be done without any side effects
to the cluster.

--

Mike
Principal Mentor
Solid Quality Learning
"More than just Training"
SQL Server MVP
http://www.solidqualitylearning.com
http://www.mssqlserver.com