We are looking to create an Active/Passive cluster with two named instances.
In this scenario, would the data files associated with the different
instances need to be placed on different LUNS are could all of the data files
be placed in the same LUN?

Is a failover logged in Cluster.log?  If so, what text would be recorded?
Thank you.

Hey everyone,
We are running Windows 2003 and SQL 2005 in a cluster.  We now need to
install a service pack for SQL 2005.
Anyone know of a step-by-step white paper on how to do it in a cluster?

In Cluster Administrator, when you "Move Group" from node A to node B in a
active/passive cluster, what log is this recorded in, and what would the
verbage look like?
Thank you.

I have a two node active/active cluster setup.  when i stop the cluster
service one node A all resources fail over to the other node B, but the SQL
Server, SQL Server Fulltext and Analysis Services state = failed and the SQL
Server Agent state = offline and they will not come ...

Greetings all,
We need some help understanding our options.  We have a 64bit W2003 SP2 &
SQL 2005 SP2 currently running as a single instance.
We know that Reporting Services (RS) is not cluster aware.  We currently

I'm attempting to add three nodes to a SQL 2000 two node cluster.  All three
servers have been added but I cannot failover the sql instances from the
previous two node cluster to any of the new servers.  I did notice that there
were SQL services for the old instances missing on ...

Does anyone have a kb article on how to restore the master database in a sql
2005 cluster?

basically I want to do a proof of concept and get used to setting up
clustering. I am ready to buy 4 cheap boxes and have 2 for the cluster nodes,
a main server and a client. These 2 cluster boxes each have 2 PCI slots free.
What I want is for the 2 nodes to access a central disk ...

I have a active/passive clustered SQL Server 2005 Enterprise. If the
data file becomes corrupt, I've lost my high availability and because
the database is over 200GB, a restore operation will take hours. Does
anyone have any suggestions for creating a warm stand-by in a

I am consilidating my SQL servers and wanted to get recommedation for
consolidating 15 Servers that are all 3.5 GB Memmory,CPU utilization uner
30%, 8 Processors with an average of 7 databases per server and with over 100
GB of data.  How many instances and nodes using DL 385 ...

We currently have an Active/Active SQL 2000 setup.  I'm in the process of
adding 3 more nodes to the cluster.  The problem I'm having is when I go to
add a physical disk to the new resource group I am not able to see the disk
in the pull down menu therefore I cannot install the ...

Basically, we have a 24/7 database on the MS SQL 2005 cluster. Last week, the
cluster failed due to the NIC fault. The service was stopped for almost 4
hours. The penality is heavy. My manager want to add another layer to ensure
the availability of service, such as data mirroring ...

Has anyone seen a sql 2005 cluster with very high wnilogon.exe processes?
The passive node has a winlogon.exe using 2gb of ram, and the active node
has 1.7gb in winlogon (and 1.6gb in sqlserver.exe)...
Haven't bene able to locate the issue (if there is one) after restarting

Are there any reasons why the SQL Server Service of an SQL Server 2005
Cluster (active/passive), should not be restarted using Management Studio?
Is there any reason why the SQL Server Cluster should be taken offline
before restarting the service?