I know there is the heartbeat that checks for ping... But i also believe
there is  a sql related check too ..right ?
I guess what im getting at is ..if the server is super busy that this sql
related check cannot even get a thread to connect, will the cluster fail ?

Our organization has a medical application that is dependent on 6
independent SQL databases that are loaded on 1 SQL 2005 server/instance.
Can  a "SQL 2005 High Availability Database Mirror" be used to mirror all
six databases and automatically failover.

I have to set up a new SQL 2005 instance for my company this weekend and I
have no experience working with SQL clusters.
Can someone help me with the detailed steps of what will be required and
involved in setting up the new instance?

We are having difficulty uninstalling a named instance from our 2-node,
active-active cluster.
When we try using the CD setup program, none of the instances appear in the
drop down to select which instance to remove.  I have heard that there is a

Thanks in advance for any assistance.
We moved from a single-server instance to Active/Passive cluster and
we are experiencing a higher CPU utilization than we saw on the single
server. Is there any reason why the CPU utilization would increase

Have any of you ever run across a problem in SQL Server 2005 running an
active/passive cluster on Windows 2003 SP1 Enterprise, where you can connect
to the server via Management Studio open tables, see dbs, open properties.
Everything runs fine with the exception of being able to ...

I'd like to poll everyone out there to see what the approach is with regard
to clustering, two nodes. Do you prefer active/passive or active/active, and
why?
TIA

I'm having difficulty rebuilding the master database with a new collation.
I'm running the following from a command line:
C:\>start /wait c:\SQL_Server_2005_x64\Servers\setup.exe /qb VS=SDBAHSQLPC01
INSTANCENAME=SDBAHSQLPV01 GROUP="SQL Group"

Where can i find enhancements made to SQL 2008 clustering ? I heard that we
could now run SQL patches without taking the entire cluster offline as part
of the new feature. Is that true ? If so, where can i read more ?

Is there a document describing how to setup a multi-instance SQL 2000
Enterprise Cluster in a single instance failover environment on Windows 2003
R2 Enterprise?

For some reason when i try to install a failover cluster  SQL2005 Std. on
WIN 2003 ENT I am getting  the error  "The Virtual Server name you provided
is not valid. To proceed, provide a virtual server name. For more
information, see Instance Name, in SQL Server Books Online."

SQL Server Std Edition SP2 on windows 2003 EE R2 SP2 AWE enabled
8 GB of RAM SAN attached 1 LUN
Min server memory @ 0
max server memory @ 6656

Hi. Wonder if anyone can offer me some advice?
I'm currently involved in setting up some new kit prior to an upgrade of SQL
Server 2000 Standard on a single Win 2000 server to SQL Server 2005 Standard
x64 on a single node Failover Cluster. Additionally databases are to be held

In a cluster environment for SQL what is the best way to find out the
name of the real physical computer? I know the SQL instances are
virtual and the but I want to find out what real server is it running
on. Is there a way to find out via EM or via T-SQL? I am sure others

We are using SQL Server 2000 SP3 on Windows 2000 Advanced Server 2000
SP3. Hardware is a cluster with two servers: Compaq Proliant DL580 with
external storage device Compaq MSL 1000(Raid 5).
Since last week we encountered server become very slow on and off (about