I have a sql server 2005 cluster which I have to move from one subnet to an
other.
Concerning node ip, cluster, sql ressource and msdtc ip's: In which order
and how should this be done? How about the msdtc service - could there be any

is there any way to add a new node to the cluster without getting downtime
when applying service pack 1?
Let me elaborate. Let's suppose we have a n-node-cluster and want to add
node n+1. No problem so far, we add the node, SQL Server 2005 RTM gets

We are running portal server front end (3 servers) and sql2k clustered
(active/passive) as the back end.  We would like to upgrade to sql2005.  Any
suggestions on the best method?
thanks,

Is it possible to set timeout for method Open of MSCluster.Cluster class?
Thanks in advance
GrzesB

I have a failover cluster with SQL Server 2000 SP4 installed on it. The SQL
Server is on the current active node which is SQLUU. last night, I took the
SQL Server offline from cluster administrator, and then immediatelt bring
online again. However, I see the SQL is trying to be ...

How many nodes can you have in a cluster?
We currently have 2 nodes one active one passive, running windows 2000 SP4
with SQL 2000 ENTERPRISE EDITION.
I ask because I want to make our setup more tolerant, so any advice is great.

I have a 2 node cluster running Windows 2003 R2 with SQL 2000 sp4 on it that
is placed in our DMZ.
There are two virtual servers
           websqlcl (x.x.x.191) and websqlcl2 (x.x.x.192)

We have a 2 node active/passive cluster running SQL2K SP4.  I want to add
another node and make it Active/Active/Passive with the one active node
running the default SQL instance and the other Active running a named
instance with the passive node taking over for both instances in ...

I am currently running a 2-node (Active/Passive) SQL 2000 cluster on 2
Windows 2003 machines.  Both machines are Dell PE4400 with a PERC3/DC card in
each one that attaches to a Dell PowerVault 221 (this is where all
databases/logs are kept).

Normally when I install SQL in a stand alone situation, the TCP/IP
Socket defaults to 1433.   However when I'm installing (this is just
testing for now) the default port gets set to "0".
Do I need to manually change it back to 1433?

Well, we have a SQL cluster setup as active/passive, W2K + SQL2K (sp3). We
need to do some loading test on this box to evaluate its capacity. We already
have AWE enabled with 8GB. Our disk is SAN. My question is:-
1. Which address Performance Monitor should use to monitor the box, ...

Is this a suported configuration?

Hi all,
we have a 2 Node Active-Active SQL Cluster and wanted to enlarge disk space.
The following steps we made:
- Backup RAID 5 (Image)