Can one node be configured to belong more than one clusters? For instance,
if we have three nodes: N1, N2, and N3, can we configured N1 failover to N3,
and N2 failover to N3? Both N1 and N2 has their own default SQL server
instances. Thanks for any input.

easy question: Which type of RAID should I use for SQL database + logs in
Cluster ?
Thanks.
Marek

I have a cluster with 3 nodes, currently running 6 instance of SQL2005 at
SP2. Each node is Windows Server 2003 SP2. I have tried to install a new
instance but it keeps failing, can anybody help me?
Below is the error I found in one of the setup log files.

I have some questions...I'm looking for the right answer.
Here it is.
If a cluster has three nodes with 4 processors in each, what is the number
of the processor license do I need? Among three nodes in a cluster, only 1

I have a 2 active/passive cluster running Windows Server 2008 Enterprise.  I
just installed SQL 2005 Server, which had no problems.  However, when I look
at failover cluster managment, under Services and Application, SQL server is  
listed as failed, and SQL server Agent is listed ...

I have added a new instance for SQL 2000 SP4 on to one of the node in the
clustered server.
after i have add the second server for fail over, i am getting this error in
the other server when trying to fail over to the other side.

On the installation screen we have two options
1. New SQL SERVER failover cluster installation.
           Launch a wizard to install a single-node SQL SERVER 2008
failover cluster.

I have been tasked with setting up a sql server 2008 active-passive cluster.
To start with I have been giving two windows server 2008 servers for
development / testing.
windows failover clustering and MSDTC has been added to these servers.

Could you help me find answer for this question please?
I’ve just set up two node fail over cluster (SQL 2008 and Windows Server
2008).
In documentation is that under with cluster service is working should have

I have a two server cluster with 32GB mem. I have six SQL instances running
with the default memory settings. Min mem 0 Max all.
When I look at Taskmanager process tab I see the six sqlserver.exe's and the
most any are using is 250mb. Butr when i look at the perfromance tab it ...

I have a scenario involving a two node cluster each running a SQL 2005 (x64)
instance. Each node has 64GB of RAM and 'lock pages in memory' is set.
If I configure, via 'Max Server Memory', each node to use say 50GB of RAM -
what happens during a failover. I'm guessing that because ...

Can I configure a SQL 2008 Instance Directory on a Cluster Drive? I would
like to put the system DBs on a cluster drive. But when I select a cluster
drive, it give me an error:
------------------------------

We have a situation where we have Qa environment SQL server 2005/2008 with
multiple instances each with different collation.
I have been asked to move this server under cluster environment, my question
is prior to installation would it be wise or mandatory to prepare

I was curious if there was a documented check list similar to the list
available in the Windows 2003 Server Clustering manual that describes how to
verify step-by-step a fail-over cluster in 2008.  For example Initiating a
failure of a resource or a drive or powering off a node ...

When I run the cluster validation tool it returns an error on the network
setup. It creates a virtual adaptor 13 on both nodes with the same MAC and
apipa address and fails the validation.
Question - how do I either change the address & mac or setup the virtual