dbTalk Databases Forums  

2000 Cluster

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss 2000 Cluster in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #101  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: 2000 Cluster - 01-14-2008 , 02:52 PM






Technically, upgrading a stand-alone installation to a clustered
installation is possible in SQL 2000. It is also highly NOT recommended.
There was a good reason the feature was pulled from SQL 2005. I suspect it
was the high failure rate amongst those that attempted it. Those who could
pull it off knew better than to try.

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP





"Kevin3NF" <kevin (AT) SPAMTRAP (DOT) 3nf-inc.com> wrote

Quote:
Apples to green apples

yes, the Windows cluster has to be built adding shared storage and
(hopefully) a 2nd node.

But...

Take the existing SQL Server, make it part of that Windows cluster, stop
the services, move the databases to the Shared drive(s) and run the
"upgrade" from the Installation wizard. All this is really doing is
copying binaries to the new node(s), and creating the various registry
entries that point to all the right places.

I'll stop now just trying to be clear to CLM that the new server he is
building can be bumped to a Clustered SQL Server.

Have a great day!

--

Kevin3NF
SQL Server dude

You want fries with that?
http://kevin3nf.blogspot.com/

I only check the newsgroups during work hours, M-F.
Hit my blog and the contact links if necessary...I may be available.



"Russ Kaufmann [MVP]" <russ (AT) clusterhelp (DOT) com> wrote in message
news:1B63D899-29A8-4549-AAB1-21B21FB04567 (AT) microsoft (DOT) com...
"Kevin3NF" <kevin (AT) SPAMTRAP (DOT) 3nf-inc.com> wrote in message
news:OsZfpluVIHA.4768 (AT) TK2MSFTNGP02 (DOT) phx.gbl...
Geoff's post refers to SQL 2005.

CLM's original request only specifies:
We're going to have to move data to a new 2000 SP4 server.

with no mention of 2005...

No difference. You have to build the cluster first.


--
Russ Kaufmann
MVP - Windows Server - Clustering
ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp

The next ClusterHelp classes are:
Mar 10- 13 in Denver
May 12-15 in New York





Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.