I would like to build an Active-Active model with two nodes (Win200 AdServer)
question is easy: which are the most important parameters as well as little
things that then are so important when everything is running in production?
Same memory for both?

I already feel as if I know the answer to this question but I want to
confirm my thoughts before moving forward.  We have a clustered default SQL
instance running W2K3 Enterprise and SQL2000.  We were having a problem last
week that we could not solve via SQL.  We decided to ...

I have a clustered enviroment made of 2 win2k advanced servers
clustered in a network. Servers are running sql 2000 that hosts a third
party database X. Now X was working perfectly until these servers were
clustered. Users accessed X via a citrix client. Any idea as to why

After serious storage problems, I need to uninstall a cluster sql 2000
64 bit over a two windows 2003 servers 64 bit Itanium Dell PowerEdge
7250, attached a storage HP XP 1024, and after reconfigure the SQL
Server failover cluster. I known, it's a big task, do you have some

After I installed new 4 new disks in the SAN and added them as resources in
clusteradministrator im not able to see them when I try to expand the
filegroup. I can see the disk in "My Computer", but not in the SQLServer, is
there something extra there should be done to enable the ...

we have 2 node Active/pasive cluster system, and thinking to convert it to
active/active. In order to determine all pros/Cons I'm trying to find out all
comparison issues.
Any article,comment  on this, will be appreciated.

We have a SQL server 2000 cluster, built on Windows 2000 Advanced server.
We are using an Active / Passive configuration which has 4 instances of SQL
Enterprise, and 1 Instance of IIS.
Both boxes are identical, and clustering works just fine.

I've built a single-instance Win2k3sp1 based cluster and installed SQL2ksp3
on it.  The servers are symmetrical and have 8GB RAM ea.  Currently, I plan
to enable /3GB switche in boot.ini, and will also enable /PAE and AWE.  I
left the pagefile (about 11GB in size) on the c:\ ...

i have a microsoft sql 2000 server sp2 (on purpose because of erp, jde
edwards) set up on a windows 2000 server cluster (advanced server - 2 nodes),
with 4 gb of ram
i have already included the /3gb switch in the boot.ini file. 'awe enabled'

We have a HP EVA 5000. SQL 2000 Cluster is using 150 GB(Drive R:) on the EVA
for all database files. I want to defragment Drive R:. Fýrst I intend to
stop SQL Server and SQL Server Agent,then backup up all system and user
databases to Tape Backup(.mdf and .ldf files) ...

We will build new clustering SQL Server. The question is that what kind
drives configuration for user-defined database data files and transaction log
files will improve performance, RAID 1+0, RAID 0+1, RAID 5 or RAID 10 etc.
Regards!

The KB article, 899761, is silent regarding applying this hotfix to a
two-node cluster.  Please guide me in how this should be accomplished or
provide me with a reference on this subject.
Thank you.

I understand from Microsoft that a SQL Server 2000 Cluster on Windows
2003 Enterprise can be run with a non-administrative service account
but I have not been able to get this to work- the SQL installation
fails with "This operation returned because the timeout period expired"

Unfortunately several of my sql users need tot run cmdexe jobs
(dts-packages). To keep them from totally destroying my server I
configured a proxy account with not to much rights on the files system.
For each virtual server I created a separate temp dir for the proxy user.

hello, I am going to install SQL Server 2000 on Windows2003 server with
(Active/Passive) configuration
I have db space as 600 gig , ranges 1 gb to 90 gb. i have one concern about
how log failover to passive server will take in case of it need? whether it