We are currently planning for two-node SQL 2005 cluster for some of our
applications.  We are hearing that SQL 2005 cluster doesn't handle being
patched with MS hotfixes well. It probably matters what kind of hotfix is
being applied but does anybody know what is the best ...

The MS Cluster install went well, the SQL 2005 went great as well. No errors
at all...that was until I tried to install SP1 then tried installing SP2. I
get the same error every time. It has to do with a recent install of KB
921896. The error  on the summary.txt file is 28017.

I have seen various posts on how to move SQL databases files on an
existing SAN to a new SAN. Geoff, Rod, Russ and others have provided
valuable suggestions.
I need help clarifying something -- although the files can be moved by

I have an existing Acitve/Active SQL2000 Cluster on Win 2003R2, and would
like to add an additional node to the cluster.  I dont initially wish it to
be an active node.  How do I an a node in this scenario?  I am of the
impression the only way to kick of an install involves ...

I am setting up 2 Windows 2003 R2 Ent servers with SQL 2005 Ent in a Cluster.
Is it possible to run them in a NLB type config and write to the same disks
on our SAN?

I have 2 new servers I want to setup for clustering of SQL 2005 Enterprise
Edition. Do I setup a Windows Cluster  and setup SQL 2005 on both servers? Do
I setup Windows then setup the Clustering within SQL 2005? Or both?
Thank you for your assistance.

I know there is a public network for all application communication and one
for hearbeat .
Are there any more ?
Does one connect the hearbeat network to like a local hub for the nodes or

I've added another cluster resource drive to the group and sql 2000
instance is in. Sadly, the instance is not recognizing the drive,
which is making it pretty hard to create backup devices on the new
drive. which is why i added the new drive. Is there some trick to this

Can additional nodes be safely added to the cluster without taking the
entire cluster offline ?
So for instance, if we have a 2 node single cluster today, can i add 2 more
nodes to make it a 4 node 3 instance cluster without taking the current 2

I was trying to find information on the OS and SQL requirement for SQL 2005
cluster. Can SQL 2005 cluster run on Windows 2003 32 bit standard edition SP1
running SQL 2005 SP1 32 bit standard edition?
Thank you.

How many active nodes can MSCS have per cluster ?

I have a SQL 2000 SP3a server running clustered on Windows 2003 Enterprise
Edition SP1.
We have a need to bring in a newer/faster Windows 2003 server, however in a
non clustered environment.

Currently we use Log shipping between our active site and our DR site. The
question I have is when we do DR testing at the DR site to test
recoverability, we have to recover all those Log shipped databases which
means we are exposed until our DR tests are completed.