Thursday, February 9, 2012

# of supported failover nodes

Hi all!
how many failover nodes are supported by SQL SRV 2k on a windows server 2k3
EE cluster?
I have only found information about 4 failover nodes on 64 edition of sql.
Tks in adv.
Regs.
SQL2000 supports whatever the OS supports. On Windows Server 2003 Enterprise
Edition that would be 8
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
"Axyl104" <telodico@.te.it> wrote in message
news:OLkn%23F1XEHA.808@.tk2msftngp13.phx.gbl...
> Hi all!
> how many failover nodes are supported by SQL SRV 2k on a windows server
2k3
> EE cluster?
> I have only found information about 4 failover nodes on 64 edition of sql.
> Tks in adv.
> Regs.
>
|||SQL 2000 supports a maximum of 4 nodes in a cluster.
PRB: Virtual SQL Server 2000 Installation Fails on Cluster That Has Eight
Nodes
http://support.microsoft.com/default...&Product=sql2k
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
message news:u0V01K2XEHA.3520@.TK2MSFTNGP10.phx.gbl...
> SQL2000 supports whatever the OS supports. On Windows Server 2003
Enterprise[vbcol=seagreen]
> Edition that would be 8
> Cheers,
> Rod
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering
> "Axyl104" <telodico@.te.it> wrote in message
> news:OLkn%23F1XEHA.808@.tk2msftngp13.phx.gbl...
> 2k3
sql.
>
|||I agree but at Tech Ed 2004 USA someone from Microsoft said what I wrote, in
a SQL 2005 presentation. Since I have not tested it. I am going with what
the MS Employee said at Tech Ed.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:%23bu3%23m3XEHA.384@.TK2MSFTNGP10.phx.gbl...
> SQL 2000 supports a maximum of 4 nodes in a cluster.
> PRB: Virtual SQL Server 2000 Installation Fails on Cluster That Has Eight
> Nodes
>
http://support.microsoft.com/default...&Product=sql2k[vbcol=seagreen]
>
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
> message news:u0V01K2XEHA.3520@.TK2MSFTNGP10.phx.gbl...
> Enterprise
server
> sql.
>
|||When I asked this question earlier, I got a direct reply from the
Microsoftie who was program manager of the install team. 4 nodes is all you
get with SQL Server 2000. It is due to a limit in the installer, not a SQL
cluster limit per se.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
message news:ulx75u3XEHA.1652@.TK2MSFTNGP09.phx.gbl...
> I agree but at Tech Ed 2004 USA someone from Microsoft said what I wrote,
in[vbcol=seagreen]
> a SQL 2005 presentation. Since I have not tested it. I am going with what
> the MS Employee said at Tech Ed.
> Cheers,
> Rod
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering
> "Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
> news:%23bu3%23m3XEHA.384@.TK2MSFTNGP10.phx.gbl...
Eight
>
http://support.microsoft.com/default...&Product=sql2k[vbcol=seagreen]
> server
of
>
|||SQL Server 2000 Failover Clustering (32-bit) supports four nodes on Windows 2003 Enterprise Ed cluster server (even though Windows 2003 EE supports 8 nodes).
SQL Server 2000 Failover Clustering (64-bit) supports upto eight nodes on Windows 2003 EE (64 bit) and Windows 2003 DataCenter (64-bit) server cluster.
Rod -- you said "I agree but at Tech Ed 2004 USA someone from Microsoft said what I wrote, in
a SQL 2005 presentation. Since I have not tested it. I am going with what
the MS Employee said at Tech Ed."
-- SQL 2005 presentation ==> Yukon - our next release. You go the right information. i.e. in SQL 2005, we will support 8 nodes.
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way
to do this is to visit the following websites: http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx

No comments:

Post a Comment