Clustering with SQL2005 Standard Edition

I see that the new SQL 2005 Standard edition supports 2-node
clustering. Does that mean that Standard edition could be used in a 4
node N+1 scenario set-up as follows:
Node 1: File Server
Node 2: Exchange Server
Node 3: SQL 2005 Standard
Node 4: Dedicated failover node for 1,2 & 3
Only Nodes 3 and 4 will ever be running SQL2005. So would standard be
suitable or would SQL2005 Enterprise edition be needed?
Cheers,
Ian
Ian Robinson, Belfast, UK
<http://www.canicula.com/wp/>
Hi
Standard 2005 would suffice, but you still need the Enterprise Edition of
the Windows 2003 to do clustering.
Be very careful as to the features you need from the SQL Server edition.
There are a lot of performance features that are only available on
Enterprise Edition.
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/
"Ian Robinson" <junk@.canicula.com> wrote in message
news:0001HW.BF93850800056921F0386550@.news.gradwell .net...
>I see that the new SQL 2005 Standard edition supports 2-node
> clustering. Does that mean that Standard edition could be used in a 4
> node N+1 scenario set-up as follows:
> Node 1: File Server
> Node 2: Exchange Server
> Node 3: SQL 2005 Standard
> Node 4: Dedicated failover node for 1,2 & 3
> Only Nodes 3 and 4 will ever be running SQL2005. So would standard be
> suitable or would SQL2005 Enterprise edition be needed?
> Cheers,
> Ian
> --
> Ian Robinson, Belfast, UK
> <http://www.canicula.com/wp/>
>
|||Hi Mike,
On Sun, 6 Nov 2005 18:20:28 +0000, Mike Epprecht \(SQL MVP\) wrote
(in article <#I#xC7v4FHA.3880@.TK2MSFTNGP12.phx.gbl>):

> Standard 2005 would suffice,
Good stuff.

> but you still need the Enterprise Edition of
> the Windows 2003 to do clustering.
Yep. I thought I would.

> Be very careful as to the features you need from the SQL Server edition.
> There are a lot of performance features that are only available on
> Enterprise Edition.
I've told the client in question that. We're doing an infrastructure
upgrade and putting a base SQL installation so that it'll be there when
they go to market next year to get a new LOB system based on SQL2005.
I've told them that if they go with Standard edition it may not suit
the development house they choose. They are okay with this and will
upgrade to Enterprise next year if they have to. Their call. I've
advised them to go with enterprise now but I can't force them :-)
Thanks for the answer.
Ian
Ian Robinson, Belfast, UK
<http://www.canicula.com/wp/>