Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

HOW many nodes can be there in sql server 2000 standard edition for failover clustering Expand / Collapse
Author
Message
Posted Wednesday, April 15, 2009 7:37 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC 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
Posted Wednesday, April 15, 2009 10:44 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 1:00 AM
Points: 2,993, Visits: 2,590
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
Posted Friday, April 17, 2009 8:08 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, August 19, 2014 2:02 AM
Points: 80, Visits: 564
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
Posted Saturday, April 18, 2009 9:49 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, August 6, 2013 5:22 AM
Points: 391, Visits: 87
there is no such version SQL Server 2000 Datacenter Edition

perhaps you mean Windows 2003 ... Datacenter Edition
Post #700040
Posted Saturday, April 18, 2009 10:36 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 7:21 AM
Points: 33,279, Visits: 15,450
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
Posted Saturday, April 18, 2009 10:37 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 7:21 AM
Points: 33,279, Visits: 15,450
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 »

Add to briefcase

Permissions Expand / Collapse