act/pass cluster upg from geerhead...

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?

>--Original Message--
>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.
>.
>
|||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@.discussions.microsoft.com> wrote in message
news:607701c42e09$ac9bede0$a601280a@.phx.gbl...[vbcol=seagreen]
> So, if I have all the programs and data and the quorum on
> a shared drive, this should be ok?
>
>
> will apply the RTM
> possible owners. So
> hotfixes (see the
> clustered if the binaries
> more shared drives.
> confers no rights.
|||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