Tuesday, March 20, 2012

3 node SQL Server cluster - is it possible

Friends
I will have three SQL Server 2000 boxes at my location. Is it possible
for a SQL Server cluster with 3 nodes?
I will like SQL servers running on their own boxes but to failover to
other member nodes if a box fails..
Thanks
Your best bet would be a four node cluster with three SQL instances. That
way there is a "clean" node ready to assume any single failed instance. If
you don't have a free node, you run into some compromises on memory
allocation so you can "stack" instances.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"D Goyal" <goyald@.gmail.com> wrote in message
news:1134658318.825088.97770@.z14g2000cwz.googlegro ups.com...
> Friends
> I will have three SQL Server 2000 boxes at my location. Is it possible
> for a SQL Server cluster with 3 nodes?
> I will like SQL servers running on their own boxes but to failover to
> other member nodes if a box fails..
> Thanks
>

No comments:

Post a Comment