SQL Stand Alone to a Cluster

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bryan - 28 Mar 2005 21:59 GMT

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

Reply to this Message

Mike Epprecht \(SQL MVP\) - 28 Mar 2005 22:06 GMT

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@epprecht.net

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

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

> All,
> I am in the process of upgrading windows 2003 ent with SQL2000 ENT stand
[quoted text clipped - 6 lines]
> TIA
> Bryan

Reply to this Message

Geoff N. Hiten - 29 Mar 2005 04:15 GMT

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

> Hi
>
[quoted text clipped - 27 lines]
>> TIA
>> Bryan

Reply to this Message

Bryan - 29 Mar 2005 15:05 GMT

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

> 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
[quoted text clipped - 36 lines]
> >> TIA
> >> Bryan

Reply to this Message

Geoff N. Hiten - 29 Mar 2005 15:16 GMT

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

> So, Your telling me, that you dont know the steps involved.
> Honestly, I could have thought up of rebuilding the server. Thanks
[quoted text clipped - 45 lines]
>> >> TIA
>> >> Bryan

Reply to this Message