Just want to know possible scenarios for switching of clusters any
whitepaper .
for e.g. when services are stopped on one node cluster will switch or when
we move the group to other node the cluster will fail what other

I am going to be installing SP3 on an active /active cluster tomorrow and
would like some help if possible.  We have two virtual SQL SP2 servers (one
is a named instance).
I have been reading up on the documentation and all, but have not found any

We recently built a W2K Advanced server, SQL Ent 2000 cluster.
Each node of the cluster had 2 NIC ports:
1 NIC was used for Cross over cable
Other NIC was used for LAN.

Hi Group
SYSTEM:
Clustered SQL Server 2000 on Windows 2000 (2 servers), with RAID 1+0, 6
drives (Total of 24 20GB hard drives with mirroring/striping).  4 GB RAM /

Verifies of my backup jobs are repeatedly failing from "Cannot Open Device"
errors on my new Win2003 cluster when run from the maintenance plan job.
When I try the path, it is valid and I can run the verify statement manually
for the file and it completes successfully.  Has anyone ...

Hi
We are running SQL server in a cluster environment  and Hyper threading are
enabled in that servers.  The application and Database servers  are
different.  The appliactions stores 2 MB size of acrobat files to the table

I need to increase performance of our SQL enviroment and i dont really want
to put one BIG server in.
What would be the best way of load balancing 1 SQL database over 2 servers?
My first thought was 2 servers clustered with a SAN and use SQL replication

Due to re-engineering of our Network infrastructure, we need to change the
SubNet Mask Properties in the SQL Virtual IP resource. We are using SQL 7.0
clustered on 2 Active & Passive nodes. The SubNet masks and Gateway of the 2
nodes also required to be changed. IP address remain ...

I have win 2000 A.S. with SQL enterprise edition in an active/active
configuration.
Is it possible to to restore a backup of sql bases (master, etc) on a same
hardware configuration, but with virtual server sql renamed ?

Is there an elegant way to clear out the ADO connection pool used by the SQL
Server State Service following a cluster failover?
We are using a SQL Cluster to store both the ASP Session State database and
our application database.

Hi there. I'm new to this clustering mularky and I've a couple of questions
regarding a linked-server query I have.
1. Server A is a regular server. Server B is a clustered server with shared
storage.

I have a windows 2003 cluster
with sql-server 2000 sp3
and a named instance.
I wanted to installation the hotfix ..859, but the installation failed

we have a w2k3ee server cluster running one instance of exchange as failover
cluster.
We now would like to use the passive node for a sql instance.
A seperate drive has been installed and initialized.

We want to upgrade our two nodes active/passive cluster from 3.5 GB RAM to 6
GB. We add the RAM in the passive node first, set the /PAE switch and restart
window. We then failover the Cluster Resources to the passive node. However,
the operation failed without giving me any error ...

We have had a working SQL Server 2000 SP3 (default instance) on two node MS
Windows 2000 Advanced Server with MS Cluster servcie working for over a year
now.
The shared Q: and E: drives are actually two seperate LUNS from a SAN