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

Question

Post reply

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

shanila_minnu

Hall of Fame

Points: 3465
More actions
April 15, 2009 at 7:37 am

#103721

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

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

happycat59 One Orange Chip Points: 29386 More actions · Answer 1

SQL 2000 Standard Edition does not support clustering.

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

franco SSCommitted Points: 1642 More actions · Answer 2

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

Ralf Dietrich SSChasing Mays Points: 658 More actions · Answer 3

there is no such version SQL Server 2000 Datacenter Edition

perhaps you mean Windows 2003 ... Datacenter Edition 😉

Steve Jones - SSC Editor SSC Guru Points: 734418 More actions · Answer 4

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

Steve Jones - SSC Editor SSC Guru Points: 734418 More actions · Answer 5

Sorry, fatfingered the past post.

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