Well the subject pretty much covers it, We have a Single node cluster running
SQL 2000 on windows 2003 Server, having completed the construction of our
second datacentre, we now need to add a second node to it. Unfortunately the
suppliers who set up the original cluster are long ...

I am trying to install a named instance of SQL Server 2000 on an
Active/Passive 2-node cluster on Windows 2003 Server. The installation
proceeds until near the end, then I get the message: "The cluster resource
failed to come online." When I click OK, a message appears saying I ...

Using Windows clustering requires too long a failover time for my company's
uptime requirements.  While SQL 2005's mirroring decreases the failover
time, it also only allows me to mirror to one server, thus putting me in a
rough spot for DR.

I am having difficulty setting up my disks on my SQL 2005 cluster.  I have a
data disk and log disk for each instance (3) but when trying to setup a new
DB, when I try to choose the log drive it does not appear.  
I remember choosing a location during setup for data files and this ...

Imagine that my server has 4GB physical memory. I have added /3GB switch to
boot.ini.
Should I enable AWE configuration for my SQL Server to use 3 GB address
space? Or AWE must only be used when I have more than 4GB memory?

As part of testing a cluster-to-cluster migration process, I am
attempting to restore the master database from an old test cluster
into a new one.  I've read quite a bit about this online, and it looks
like a relatively easy procedure.  These are the steps I'm following:

I installed the windows cluster and a one node failover sql cluster, and
both runs without problem.
When I try to install the second node in the sql cluster the installation
will be interrupted.

I read the useful tips about proper cluster shutdown orders. We just set up
a 2 node single instance (active/passive) Win2003 / SQL 2005 cluster.
Unfortunately our customer asks for a script or batch to shutdown the
cluster nodes in a clean way for maintenance purposes.

I am trying to install SQL2005 onto a failover cluster.  the latest install
produced the following log file extract
-
Property(S): HeadText_ReadyInstall = Ready to Install the Program

I'd like to know how SQL Server 2005 handles identity columns in a
database hosted in a clustered environment.
I have concerns that there may be a chance that concurrent requests
could result in one or more of the servers in the cluster attempting

I was applying SP2 to our single-node cluster SQL server (x64).
All related locked processes has been stoped, except resrcmon.exe which is
part of clussvc.exe.  Should I menually stop 4 resrcmon.exe in the task
Manager and apply SP2 or is there any suggestions?

I'm installing a cluster with sql 2000 and the partition for the binaries is
a clustered resource but SQL Server won't let me install the files there...
Is this correct??  If so, how does SQL put the data files on the second
node?  

I'm having problem to update my SQL cluster with SQL server 2005 SP2.
Here is the summary log:
Time: 04/13/2007 18:47:03.120
KB Number: KB921896

Our production database set on cluster SQL Server 2005 (SP1). I installed
client tools for all 4 nodes. Every node should show Microsoft SQL Server
2005 and Microsoft Visual Studio 2005 after click All Programs, but in one
node the Microsoft SQL Server 2005 disappeared.

I am running a large mission critical application on a cluster.  This
is a 2003 server latest SP with SQL 2000  Enterprise  latest SP also.
This app has run for years with little change.  Today at around 3:00
all connections stopped coming in.