Showing posts with label clusters. Show all posts
Showing posts with label clusters. Show all posts

Friday, March 23, 2012

How many SQL 2000 nodes does Microsoft Officially Support on 2003?

I would like to know if I can move my active/passive SQL clusters into a more
cost effective four node cluster (3 active and 1 passive). Is there a matrix
or document somewhere on Microsoft's site that indicates what configurations
are officially supported and considered "best practices"?
I found this document
http://www.microsoft.com/technet/pro...rt4/c1261.mspx
which indicated this configuration is good to go on a Windows 2000
Datacenter OS. I believe the document is dated. With the advent of Server
2003, is a four none cluster supported on 2003 Enterprise? Is there a
document that backs this up?
Continuing on this thread, is there any type of matrix that shows what
Microsoft supports from an OS and Application standpoint for two, four, more
node clusters?
Thank you in advance for any assistance.
- John
You can build a 4 node cluster on Windows 2003 using SQL 2000.
PRB: Virtual SQL Server 2000 installation fails on cluster that has eight
nodes
http://support.microsoft.com/kb/811054/en-us
I have built and operated a 4-node, 3 instance SQL 2000/Windows 2003
Enterprise Edition cluster. The procedures and practices are a bit more
complex than a two-node cluster, but nothing radically different.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"John Robel" <John Robel@.discussions.microsoft.com> wrote in message
news:7723B6AA-72AF-4B5B-91E1-7CEF9F19DBC7@.microsoft.com...
>I would like to know if I can move my active/passive SQL clusters into a
>more
> cost effective four node cluster (3 active and 1 passive). Is there a
> matrix
> or document somewhere on Microsoft's site that indicates what
> configurations
> are officially supported and considered "best practices"?
> I found this document
> http://www.microsoft.com/technet/pro...rt4/c1261.mspx
> which indicated this configuration is good to go on a Windows 2000
> Datacenter OS. I believe the document is dated. With the advent of
> Server
> 2003, is a four none cluster supported on 2003 Enterprise? Is there a
> document that backs this up?
> Continuing on this thread, is there any type of matrix that shows what
> Microsoft supports from an OS and Application standpoint for two, four,
> more
> node clusters?
> Thank you in advance for any assistance.
> - John
sql

Monday, March 19, 2012

how many clusters can i set up ?

A slight confusion. I have created a windows cluster with 2 nodes and a
single instance of SQL 2K cluster
Is it possible to create many windows clusters? I was looking at the Cluster
Admin and there is an option to create a new cluster ... Why would one want
to do that especially with only 2 nodes ? Please let me know. Using windows
2003
One server can only be an active participant in one cluster at a time, but
the cluster administrator tool can be used to manage (and create) all
clusters in your environment. You can have as many clusters in your
environment as you'd like...obviously this is limited to the amount of
hardware that you own.
So, you don't need to run cluster administrator on the nodes that you are
using to form your cluster...it can be run on any host that has the utility
installed (all W2K3 Ent Servers).
Regards,
John
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:%23FJmV3TLEHA.4080@.TK2MSFTNGP12.phx.gbl...
> A slight confusion. I have created a windows cluster with 2 nodes and a
> single instance of SQL 2K cluster
> Is it possible to create many windows clusters? I was looking at the
Cluster
> Admin and there is an option to create a new cluster ... Why would one
want
> to do that especially with only 2 nodes ? Please let me know. Using
windows
> 2003
>