Is this supported?
Details:
2-node Win2008 Ent. Cluster with multiple subnets. Able to successfully fail
back and forth no problem with one subnet coming online at one node and the

We have a 32 bit SQL 2005 active-active clusterd server, with 8GB RAM in
each node. What should we do with boot.ini?
1 /3GB
2 /PAE

i understand that the technology for clustering are N+1 or N+m. However, Can
1 deploy sql cluster nodes in odd numbers? Example, 3 nodes with
active/active/passive or 5 nodes with 3 active/2 passive ??
Many thanks!!

I have recently configured two node SQL 2005 failover cluster. I'm wondering
if anybody has some king of document/article on how to backup the cluster
(both servers and databases). I'm planing to use NetBackup 6.5 for this
purpose.

first of all thank you very much for your help!
I have two questions
I have a SQL Server 2005 on a Windows 2003 failover cluster. Both nods
are without Service Pack and I want to upgrate them to SP2 but I'm not

I am currently involved with a production environment that is made up of a
two node Acitive/Passive cluster.
I am conscious (and so too of course is the business) that the Passive node
is doing absolutely nothing, all of the time other than of course waiting to

I am new to sql installation on clusters, they were installed before me.
I have 2 questions:
1. how do I install 2 virtual servers on 2 node cluster? I only know how to
install 1 virtual server.

Anyone have any ideas why a SQL 2005 active/active configuration, would be
noticibly slower than if I move one of the active nodes to the other and run
on the same node?
It doesn't matter which node I put them on, when I run them on 2 different

I have added a new sql cluster drive resource into my cluster and brought
this online succesfully. However, SQL still cannot see this drive when I try
to add new database files.
Any ideas would be gratefully received!

is there a newsgroup which supports SQL Server 2008 failover clustering
based on RC0?

how do i load balance sql servers? active/passive is not going to do it as 1
node is not able to handle the load

I have run into issue with proxy account in cluster - after failover from 1
node to 2nd it stops working. Also resetting the password doesn't help -
still jobs fail with an error: a required privilage is not held by the client.
Permissions on server seems to be the same.

I am using Failover Cluster API's to gather information about the
cluster. Here us tge URL http://msdn.microsoft.com/en-us/library/aa372859(VS.85).aspx
PROBLEM: I am not able to find any API which would return the IP
address of the cluster, maximum number of nodes supported by the

  Need a little bit of insight, we *might* be looking at implementing
8-Node cluster.  I can set up 2-node cluster without issue with
Active-Passive configuration; when setting up 2+ Node configuration I am a
bit lost.

I'm testing the installation of SQL Server 2005 clustering on a
Windows Server 2008 Failover Cluster. The Server 2008 cluster setup
went smoothly and I set up a cluster service for the SQL disks. The
installation options for a SQL cluster are all accepted and everything