HOW many nodes can be there in sql server 2000 standard edition for failover clustering

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » In The Enterprise » HOW many nodes can be there in sql server...

HOW many nodes can be there in sql server 2000 standard edition for failover clustering

Rate Topic

Display Mode

Topic Options

Author

Message

shanila_minnu

Posted Wednesday, April 15, 2009 7:37 AM

SSC Veteran

Group: General Forum Members
Last Login: Wednesday, February 13, 2013 1:19 AM
Points: 205, Visits: 499

hi
can anyone advise me the number of nodes a sql server 2000 standard edition can avail

Post #697512

happycat59

Posted Wednesday, April 15, 2009 10:44 PM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 9:45 PM
Points: 2,471, Visits: 2,065

SQL 2000 Standard Edition does not support clustering.

SQL 2000 Enterprise Edition supports 2 notes and SQL 2000 Data Centre Edition supports 4 nodes.

Post #698138

franco

Posted Friday, April 17, 2009 8:08 AM

SSC Journeyman

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 3:23 AM
Points: 80, Visits: 471

Wrong, SQL Server 2000 Enterprise Edition support up to 4 nodes.

From Microsoft:
SQL Server 2000 Enterprise Edition and SQL Server 2000 Developer Edition support up to four nodes for failover clustering, including an Active/Active/Active/Active failover clustering configuration, up to 16 total instances. This means SQL Server 2000 Enterprise Edition and SQL Server 2000 Developer Edition are not supported on a cluster with more than four nodes even if SQL Server 2000 is not installed on more than four of the nodes.

Franco

Post #699449

Ralf Dietrich

Posted Saturday, April 18, 2009 9:49 AM

Old Hand

Group: General Forum Members
Last Login: Wednesday, December 21, 2011 3:09 PM
Points: 390, Visits: 86

there is no such version SQL Server 2000 Datacenter Edition

perhaps you mean Windows 2003 ... Datacenter Edition Wink

Post #700040

Steve Jones - SSC Editor

Posted Saturday, April 18, 2009 10:36 AM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 10:01 AM
Points: 31,423, Visits: 13,735

http://msdn.microsoft.com/en-us/library/aa196694(SQL.80).aspx

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #700050

Steve Jones - SSC Editor

Posted Saturday, April 18, 2009 10:37 AM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 10:01 AM
Points: 31,423, Visits: 13,735

Sorry, fatfingered the past post.

Editions of SQL: http://msdn.microsoft.com/en-us/library/aa933150(SQL.80).aspx

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #700053

« Prev Topic | Next Topic »

Permissions