I ran the following script to move the sys logs to  diff location in the
Active/passive notes cluster server.
ALTER DATABASE msdb
MODIFY FILE (NAME = msdblog, FILENAME =

On Thursday, everything was fine.  On Friday my second virtual instance
of SQL Server was now on Node 2 for some reason.  I tried to move it
back to Node 1 and it failed and continued to go back to Node 2.  I
looked for errors in the SQL Error log and the system error logs and no

I want to use ONE (passive) SQL2k server with 2 instances of SQL running
to be the backup to TWO active servers.
Each active server is in it's own cluster....so can the passive server
belong to each active cluster and can it handle a major failover of each

I am about to upgrade my SQL server from 2000 SP3 to SP4 and they are setup
in a 2 node cluster environment. Are there any services that I would need to
take it offline or stop before I install SQL 2000 SP4 on the cluster
environment? I understand that we need to leave SQL server ...

I think i have found a bug when installing SQL Server 2005 in a cluster
environment that is member of a Windows 2000 Active Directory domain. The bug
comes in the screen where setup asks for groups in domain to services. It
doesn´t matter what group its informed, i always get a ...

Everyone,
Could someone please recommen some good books for SQL clustering over
Win2K3?
Thank you.

Have a two node SQL cluster. Node one has failed and has been evicted from
the cluster i.e. before running the SQL setup and removing the failed node
from SQL and cleaniing the SQL binaries.
What would the best way to proceed?

What is the best solution for my predictament?   I'm moving from a single
non-cluster SQL2000 STD environment (Server A) to a clustered SQL 2005 STD
environment (Server B).  Seamlessly as possible, how can I migrate the
databases from Server A to Server B?  I would like to ...