A change in networking if forcing all of our IPs to change. I have
found KB articles 230356 and 244980 with the processes for changing the
IP addresses of the network adapters and SQL virtual servers
separately, but I would like to make sure I have the overall process

Dear Sir,
I have a cluster Active/Passive cluster setting, Win2003. I would like to
know the normal procedures for shuting down the SQL Server on both nodes. Is
that needed to disable the passive node before using SQL Manager to shutdown

Environment: SQL Server 2000 (with SP3a) and Windows Server 2003
If a SQL Agent job is running on the active node when a failover occurs,
what happens to it? Will it restart on the formerly passive node (that then
becomes active)? If yes, will it restart at the same Job step that ...

I read that its possible to implement an Active/Active/Active with SQL 2000
on Win Server 2003 Ent without SAN but could not find a good step by step
howtos to it.
Could some kind gentlemen point me to a good article ? please and thanks in

Good day,
There is a 2-node microsoft sql 2000 cluster in active/active mode. .
Default instance is on node A, another named instance is on node B.
Client uses BDE while connecting. When the node A fails over to the

I have a two node cluster.  Node 1 has the SQL instance running on it and
Node 2 has the cluster group and msdtc running on it.  I can ping the SQL
virtual name and access SQL successfully.  If I move the SQL group to Node 2,
then I can no longer ping the virtual name or access ...

What's the best physical drive configuration for a SQL cluster on a SAN?  
Would creating a large (14drive/2buses) physcial RAID 1+0 array with
appropriate sized LUNs be acceptable for the quorum, tempdb, ms-dtc, and sql
tlog shared resources?

With the same application concurrency and volume, we are experiencing more
spikes in latency than before enabling the priority boost option. We are not
experiencing any buffer latch time out errors. Processor utilization is
below 45%. IO is not an issue for this system throughput ...

Hello all..
We have a Win2000 Advanced server running SQL 2000 Standard. In order to
convert this to a clustered setup, is it possible to do an in-place upgrade
of SQL? What should my steps be to make this a clustered config?

If I install SQL RS Enterprise on SQL Cluster , do I have to create IIS
Cluster Resource for the "Reports" and "Report Server " web virtual
directory ?
Norman

I have a 2 node Windows 2000 Active/Passive Cluster running SQL Server 2000
Enterprise Edition.  The cluster supports a 24x365, mission critical
application.
The nodes are currently members of a Windows NT4 domain which trusts a

Hi can't find much on whether can SQL 2000 Enterpise server be installed in a
windows 2003 cluster majority node set. Some forum say that SQL 2000 will not
run on ms cluster mns need to verify these thank you

We are trying to consolidate our servers, by moving databases to instances
(3 nodes) running under Active /Active /Passive mode.
My doubts here are
(1) Can we ever do this? I said "Yes", it may be possible but never tried.

Hi i have sql2k sp3 cluster installed on w2k3 server cluster. I can't find
exact match KBs, only found 243218 for install sql2k cluster on w2k.
followed the doc. but why the virtual server name not shown in AD as a
server after install? is this normal? I remember in w2k cluster, ...

We have A-A cluster with two server but I would like to have another cluster.
How could I connect both cluster?
Thanks a lot,