Current Config
On SAN, two node active/active SQL cluster running W2000 Server w/SP4.
Two instances of SQL, one uses default port, other does not.  Largest SQL
database on one instance is 80G and on the other instance 10G.

I am trying to learn about high-reliability clusters (for IIS and Sql in my
case) but there is a fundamental thing I don't understand about the approach
that keeps me from swallowing the high-reliability kool-aid:
Currently, I have a "non-high-reliability" (low-reliability??) ...

I have a Compaq DL380 G2 package cluster.
Prior to the Hurricane (scare) for the Houston area, all servers and the
cluster were shutdown/powered down.
I am looking for the proper shutdown/powerup procedure for the cluster.

it is good practices to have in a table (Hotels) Index not to cluster on the
HotelID column and Index to cluster on the foreign column HotelID in a table
details?
Thank you

Good day,
I have recently installed a 2 node cluster server with SQL 2000 SP3 in my
network. and have found out that users connect to the Virtual cluster server
inorder to receive SQL services but they get the replay for the physical

Hope fully there is someone who has done a similar stupid thing!  We have got
ourselves into a bit of trouble when MDAC 2.7 was accidentally (?) installed
onto our Windows NT Cluster wich still runs  SQL 7.0.  
The result was that the SQL Agent stopped working.  However the 2

I had 1 node of a 2 node SQL 2000 SP4 cluster fail. I had to rebuild node 1
and added back to the cluster
I installed SQL 2000 to the non-failed node and then applied SP4 to the same
non-failed node.

I have a 2 node windows cluster, and few days ago 1 node died, after install
again the node that failed, when i want to install the SP4 of SQL I can´t
beacuse "not all operations could be reached in all nodes". I have this
errors on the new node that i have installed.

Hello
Following on from a previous thread posted on 8/9/2005,  titled "Need advise
on SQL Server installating in MS cluster 2k3 Majority", I am currently
evaluating some solutions to install SQL 2000 on Windows 2K3.  One of the

I was doing some research about Windows 2003 Cluster with Majority Node Set
and SQL Server 2000 EE support.
I found some messages on the newsgroup saying that SQL Server 2000 is not
supported on MNS cluster.

we have a sql server instance on a 2003 cluster which was built with the
wrong collation. are their any cluster related steps that need to be taken
into consideration when running the rebuild master utility to correct the
collation? we have multiple instances running on the ...

I'm testing SQL 2005's Mirroring capabilities.
I need to implement a high-availability solution to the 1-server problem,
but without a cluster server ($$$$).
So SQL Mirroring is the key.

Microsoft’s SQL Server 2000 Failover Clustering doc states the following
under miscellaneous configuration issues:
“Disable or do not install antivirus software on your cluster” and then
gives a link to that KB article.

On a Windows Advanced Server 2000 2 node cluster with SQL 2000 SP3 installed,
I'm trying to apply SQL 2000 service pack 4, but at the point where you enter
"a username and password that is a valid administrator account on all nodes
in the cluster", I do that but get this error:  ...

Hi, when attempting to apply SP4 to a SQL cluster, we are getting the
following message.
Buffer Overrun detected!
A buffer overrun has been detected which has corrupted the programs internal