Can anyone suggest a best practice for maintaining cluster.log history? I
know there are environment variables that control the log size and a few
other things, but I've seen no good way of handling log rollover.

We have a 2-node cluster running Enterprise x64 SQL 2005 on W2K3. We
wish to install additional instances to assist management. We intend
to expand to a 3-node A-A-P cluster. Currently the heartbeat is
running via a cross-over cable with the private network being

Everyone,
I have configured a SQL 2005 cluster with two nodes. My SQL data is on a SAN
attached drive managed by NetApp which is drive x:. When I try to test the
fail over or move from one node to the other x: drive is locked by the first

Good morning, all -
Two node SQL 2008 cluster attaching to SAN storage. Dual path software in
place on both nodes. On a failover attempt (planned or unplanned), the
cluster controller node will not allow clustered disks (including quorum

Is anyone aware of a utility or a script that is available that would allow
an automated failover of a SQL Server Virtual Cluster Resource Group to
another node in the cluster?
Would like to call it out remotely via a scheduler process or SQL Agent..

We at Nob Hill Software are working on a new query tool:
http://www.nobhillsoft.com/MarieAlix.aspx?HeardVia=ptut
You can read all about it on the above web page, but basically, its a
very ambitious project to create what we call 'the query tool to end

I've set up our first sql2k8 cluster on w2k8 r2 and it works as
expected.
Now I got a funny experience with the firewall. As I want it the
firewall is started and the proper ports is open.

i upgraded sql server 2000 sp4 active/passive cluster (windows 2003 sp2)
and got into issue. Ran the upgrade on active node and the node was
upgraded to 2008 and the failover happend to passive node.but the drive
resource failed and sql server & agent offline. showing error ...

Many problems with performance and safety of your computer can be solved
easily with an updated antivirus and recognized. Antivirus Free Download
Microsoft best practices in:
http://yourantivirusfreedownloadonthissite.blogspot.com/

We have an active-passive cluster environment with Windows Server 2003 and
SQL Server 2005, where the MSDTC is working correctly, in the passive
environment is installed SQL Server 2005 used for testing, but does not
activate the service Distributed Transaction Coordinator (DTC), ...

I think I discovered a BIG problem with Windows 2003 x64 R2 SP2.
Suppose I set a setup a server and connecting it to a SAN disk and then
format this disk. When I setup a secondary server to the same disk the disk
is seen as unformatted and Windows has to initialize it again, so I ...

We have 2- node Windows Enterprise 2003 x64 servers clustered in
active/active configuration with SQL 2005 x64 installed on it. Both servers
are domain controllers.
Now we try to add another node to the cluster. This third server is not

Application uses ASP.Net 2005 and SQL server 2005
We are connecting to the web application from a local machine. When we
click a button on the app a file should be downloaded to the web
server where the app is hosted. This works with Kerberos enabled and

I'm running 4 instane SQL Server 2005 in an active/passive clustered
enviroment utilizing a SAN.
I'm running out of space on one of my LUN's for one particular instance.
This instance was originally set up as follows:

I am looking to implement SQL Clustering on a SAN with SATA drives.  While I know that clustering is not a "performance" solution, however performance is a consideration when looking for read/write times.
The solution I am exploring has fibre DAE's and FC switches with FC HBAs in ...