all groups > sql server clustering > march 2005 >
You're in the

sql server clustering

group:

SQL Stand Alone to a Cluster


SQL Stand Alone to a Cluster Bryan
3/28/2005 12:59:03 PM
sql server clustering:
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
Re: SQL Stand Alone to a Cluster Geoff N. Hiten
3/28/2005 10:15:47 PM
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


[quoted text, click to view]

Re: SQL Stand Alone to a Cluster Mike Epprecht (SQL MVP)
3/28/2005 11:06:41 PM
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/

[quoted text, click to view]

Re: SQL Stand Alone to a Cluster Bryan
3/29/2005 6:05:02 AM
So, Your telling me, that you dont know the steps involved.
Honestly, I could have thought up of rebuilding the server. Thanks

[quoted text, click to view]
Re: SQL Stand Alone to a Cluster Geoff N. Hiten
3/29/2005 9:16:23 AM
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


[quoted text, click to view]

AddThis Social Bookmark Button