All,
I am in the process of upgrading windows 2003 ent with SQL2000 ENT stand
alone server to a clustered environment. The servers that I am using are
identical,
and will be using shared storage via EMC Clariion. I have setup clusters
for fresh/new installs, but I have never upgraded/reinstall SQL
from a stand alone instance to a cluster. Any help or advice would be
greatly appreciated. What are the steps involved?
TIA
Bryan

Hi

You need to un-install SQL Server on the machine.
Create the cluster and all the resources.
Re-Install SQL Server.

If I were you, wipe the server clean before doing a cluster. Clean installs
don't cause trouble.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike (AT) epprecht (DOT) net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

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

I agree with Mike. SQL does support migrating a stand-alone installation to
a cluster, but I strongly prefer clean installs. Remember, the goal is to
have a highly available system, not to have the fastest and easiest system
setup.

Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator


"Mike Epprecht (SQL MVP)" <mike (AT) epprecht (DOT) net> wrote

So, Your telling me, that you dont know the steps involved.
Honestly, I could have thought up of rebuilding the server. Thanks

"Geoff N. Hiten" wrote:

Look up "How to upgrade from a default instance to a default clustered
instance of SQL Server 2000 (Setup)"
or How to upgrade from a local default instance to a clustered, named
instance of SQL Server 2000 (Setup)" in BOL index under the topic "Failover
Clustering".

To mis-quote a favorite movie of mine. " I said I didn't have much use for
<upgrading to a cluster>. I never said I didn't know how to use one."

Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator


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