Do I need Enterprise to do clustering?

Do I need Enterprise to do clustering?

Post by Sandy Proe » Fri, 17 Mar 2006 01:51:36


I'm confused. Reading the SQL 2000 Resource Kit, it definitely says I need
Enterprise in order to do failover clustering. But reading the product
guide on the 2005 version says Standard has clustering capabilities. Is
this something new to 2005 or is it a different type of clustering? We're
looking at clustering and it's all new to me so I'd appreciate any help you
can give me. Thanks.
--Sandy
 
 
 

Do I need Enterprise to do clustering?

Post by Geoff N. H » Fri, 17 Mar 2006 02:26:53

It is a different feature set for a different product SKU matrix. SQL 2000
requires Enterprise Edition for any clustering. SQL 2005 will allow
two-node clusters in Standard Edition. Both are MSCS failover clustering.
I have been recommending SQL 2005 Standard Edition for lower-cost clustering
with several of my clients. So far, all the systems have performed very
well.

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP

 
 
 

Do I need Enterprise to do clustering?

Post by Sandy Proe » Fri, 17 Mar 2006 03:09:43

Thank you, that is exactly what we're looking to do - a 2-node failover
cluster.
 
 
 

Do I need Enterprise to do clustering?

Post by Geoff N. H » Fri, 17 Mar 2006 04:07:52

Make sure and check out the 64-bit and dual-core processors. No difference
in licensing costs to go with either or both, but you get a huge performance
boost.

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
 
 
 

Do I need Enterprise to do clustering?

Post by Chris Woo » Sun, 19 Mar 2006 02:42:46

Geoff,

If you have to do an upgrade in place on a cluster from 2000 to 2005, can
you go from 2000 Enterprise to 2005 Standard without problems?

Thanks

Chris Wood
 
 
 

Do I need Enterprise to do clustering?

Post by Geoff N. H » Sun, 19 Mar 2006 03:42:24

You cannot do this as an in-place upgrade. You can install a second
instance of SQL 2005 on the same hardware and do a database migration. I
would take the opportunity to build a cluster based on new hardware if your
system is more than a few years old.

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
 
 
 

Do I need Enterprise to do clustering?

Post by Chris Woo » Sun, 19 Mar 2006 04:53:46

eoff,

But we could upgrade SQL2000 Enterprise to SQL2005 Enterprise in place could
we not?

Chris

Currently there is no plan to purchase new hardware for the clustered
production server.

"Geoff N. Hiten" < XXXX@XXXXX.COM > wrote in message
news:% XXXX@XXXXX.COM ...


 
 
 

Do I need Enterprise to do clustering?

Post by Rodney R. » Sun, 19 Mar 2006 04:59:51

ow that I have tested (for giggles only) and it works, but I really hate
upgrades!! Especially for HA systems!

Cheers,

Rodney R. Fournier

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner


"Chris Wood" < XXXX@XXXXX.COM > wrote in message
news:% XXXX@XXXXX.COM ...


 
 
 

Do I need Enterprise to do clustering?

Post by Geoff N. H » Sun, 19 Mar 2006 05:06:07

n theory, yes. In practice, I have heard of a lot of problems with the
in-place cluster upgrade wizard and would not recommend that path at this
time. Side-by-side or new platform is the safest way to go.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP




"Chris Wood" < XXXX@XXXXX.COM > wrote in message
news:% XXXX@XXXXX.COM ...


 
 
 

Do I need Enterprise to do clustering?

Post by Chris Woo » Sun, 19 Mar 2006 05:11:11

hank you Geoff. Not really the sort of news I wanted to hear.

Chris

"Geoff N. Hiten" < XXXX@XXXXX.COM > wrote in message
news:%23$ XXXX@XXXXX.COM ...


 
 
 

Do I need Enterprise to do clustering?

Post by Geoff N. H » Sun, 19 Mar 2006 05:18:25

t is much better to find out now than to have to reload SQL 2000 on your
cluster after a blown upgrade.

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP


"Chris Wood" < XXXX@XXXXX.COM > wrote in message
news: XXXX@XXXXX.COM ...


 
 
 

Do I need Enterprise to do clustering?

Post by Chris Woo » Sun, 09 Apr 2006 07:08:09

n update for you Geoff.

We had a clustered SQL2000 server that we tried to upgrade. It only upgraded
one node of the cluster. As a test it showed that we should not be even
trying this when it comes to our Production server later this year.

I usually listen to your advice and had expected something like this to
happen. Now I can tell the people that need to know that we will need a new
clustered server rather than upgrade in place.

Thanks

Chris

"Geoff N. Hiten" < XXXX@XXXXX.COM > wrote in message
news:Oa4Ot$ XXXX@XXXXX.COM ...