I have taken SQL Server resources OFFLINE. Will the SQL Server resources be
brought ONLINE automatically during failover or will it be in the OFFLINE
state until brought ONLINE manually?

After installing SQL Server 2005 Cluster (64 bit) on a Windows 2003 EE
server, I received the following error listed below when I tried to connect
to the Database Engine.
Error:

I got this error when I move the log file to a diff location in the cluster
environment.
Any ideas and solution?
Thanks

Ok my job is done. I have built a fully tested Windows and SQL active/passive
cluster.  Not the software guys take over but as an inquiring IT guy I can't
call it done withoout some more education.
Please feel free to answer these questions or send me to more information

A quick rant - After days of study, hours of install, and some killer
directions for Brad M McGehee I began to install a SQL Cluster on a Windows
2003 enterprise server cluster.  If only i had found that one little article
that said that the install fails if you use two Cds.

I have posted this once before but I cannot find the thread for some reason.  
I have a client that I am going to be doing some colo hosting for.  He has
two brand new servers.  He has not bought any operating systems as of yet and
will also need SQL Server.  The only thing these ...

We are currently running SQL Server 2000 Enterprise edition in a two-node
active-active cluster.  We are looking to upgrade to SQL Server 2005, but I
want one instance to be Enterprise Edition and the other to be Standard
Edition.   My co-DBA believes that there might be a ...

We have a 2003 clster with 2005 sql running across 2 nodes. We ran
SP2
on the active node, all went through successfully, but it dodnt.
It left one node SQL SP2 and 1 Node SQL SP1

I understand that Microsoft do not support SQL Server 2005 failover
clusters where the cluster instances are also domain controllers. Can
anyone tell me the reason for this? Is it to do with performance,
resilience, or some other reason?

I've inherited a cluster configuration and I'm new to administration of
clusters.
2 node 64 bit SQL running on 64 bit Windows 2003 Enterprise Edition.
I'd like to install a new instance to the cluster but do not know the

I have huge sql server databese that works on single server right now.
To the database there are at least 6 applications that update the data and
use it.
as a result of that there are problems on performance.

Can i set up clustering on a single node only to add the second node
later..i.e pending budget approval for second node as an example for holding
off on second node for now ?
Also if the answer is yes, can you add the second node without taking the

How would I go about installing the second node for SQL 2000 cluster? The
first node is up and running.

We have a single node cluster using SQL2K EE running on Win2K EE, and this
has been running fine for a year or so. We finally have our new data centre
completed, and the additional hardware installed for us to install the second
node.

Windows 2003 SP1   SQL 2000 SP3a   active/passive cluster     24x7 cluster
used by customer facing apps.  
Added a new node to the cluster and failed over.  The Full Text Indexes on
my database are “gone”.   If the resources are owned by the “old” node, I can