I have read that SQL Server with MSCS supports an Active/Active setup
via a NAS, however, DOES NOT support and Active/Active setup via a SAN. Can
anyone shed light on this? Any support documentation that would help would be
great! Thank you.

I have installed SQL 2000 Enterprise in a Microsoft Cluster Windows 2000
several times. I am trying now to install it on a MSCS Windows 2003 and I can
see there are several differences. First of all, when I did with Windows 2000
the first step was to configure the Microsoft ...

I have 2 questions, but related!
We currently have a Windows 2000 Adv server running SQL Ent 2000 as a 2 node
cluster.
Each node currently has 2 NICs installed, one NIC for the local heartbeat

is there any command to display current cluster name through query .
Thanks
ARR

I have multiple (2) instances of sql 2000 running on my windows 2003 cluster.
I have the default instance owned by server1 and a named instance owner by
server 2.  If I shutdown server 1 then my default instance fails over to
server2. Now server two is running both.  (no ...

I want to cluster my SQL server DB and just wondering what hardware (how
many systems, adapters, what will be installed on what etc)  will be required
to do the same. We are planning to use Win2k3 "Server Cluster" service for
the same.

Our server team has set up an EMC Clarion SAN with 3 sets of RAID 5 arrays,
several RAID 1 arrays and other drives/arrays for snapshots. The first
server we are installing has the data going to an 80 GB slice an an 8 disk
RAID 5 array and the logs going to a 20 GB slice on a 5 disk ...

OK please forgive me. I dont normally cross post, or ask the same question
twice, but Im in quite a pickle here.
Ive been using replication in a non clustered environment for years now. Ive
never seen extreme slowness with the initial snapshot of replication like Im

1. What is the use of Multiple-Instances of Sql server?
2. If I have only 1 Database, which Mode can I use (Active/Active or
Active/Passive) and why?
3. What is the difference between Active/Active and Active/Passive modes

I have 2 SQL servers (Active/Active) with a SAN.
I see to get a very long connection delay when connection to the second
instance from a webserver this can be upto 3 seconds.
Each Instance is active on the opersite server and the second instance is

i am briefed with the setup of a multi node Cluster Sql system
containing 4 nodes
with 3 active and 1 passive node using HP DL380s and a HP EVA 3000 SAN
with FC switched fabric.

We need to move SQL 2000 Cluster on Win 2003 server box from test to prod  
domain. What are the steps we need to follow to make sure SQL 2000 cluster is
up and running in the new domain. I know that we need to change the service
account from window services. Can we change the IP ...

I completely understand that SQL-Clustering is failover technology and not a
load
balancing technology.
1. What I'm wondering is when you go for Active/Active mode, then whether

Does clustering supports dynamic disk mirroring with SAN? As cluster
has single point of failure of disk, we want to mirror the databases.
Any ideas would be appreciated.
Thanks

Is there a way to determine the currently active node in a cluster?  I would prefer to use .Net to determine which node is currently active.  Anybody have any insight into this?  I think I could do this with WMI on Windows Server 2003, but I need to get this information for Win2k