1. In MSCS and SQL Server 2-node clustering on windows 2000 advance server,
are there any restrictions on the hardware. That is, do the 2 nodes
necessarily should have the same number of CPU and memory?
2. when we have 2 node with sql server in cluster, can we install another

I am planning to put one instance of SQL Server 2000 sp3 on a two node
Windows 2003 EE MSCS.  Each node has two channels, with each channel running
RAID 1.  The page file is in one channel, and the OS in the other.  Each node
has 4GB of RAM, and PAE enabled.  The pagefiles are ...

I have an existing sql 2k enterprise server and we're going to configure it
for server clustering. We have custom made DTC package and most of the
application use it very often.
My concern is how do we migrate this custom made DTC package to the new

Can SQL 2000 Standard edition be installed on Windows 2003 Cluster Server?
Thanks
Ayad

Hi. I need to install 2 windows 2003 servers on cluster and after configure
the SQL Server failover cluster. Do you have some guide to do this? Because I
have been material about windows 2000 and sql server, but not about windows
2003 with sql server.

I'm trying to create an index on a newly created table. I want the index to
be on the field ref. I tried running:
CREATE INDEX ref ON U_segment (ref)
but it's just sitting there! The ref is unique anyway, and there are about

Two nodes of cluster are running. When I run setup SQL after 2 seconds setup
disappears and nothing is doing. I don't have first  setup screen so I can't
choose "Virtual server" to install SQL na Cluster. But when only one node of
cluster is running setup is starting but during ...

Can anyone tell me if it's possible to rename a cluster?
Fro example, we have an Active/Passive cluster made up of two servers.
'Server1' and 'Server2' which make up the cluster 'Cluster1' is it
possible to rename this to 'Cluster2' without affecting the servers that

Currently migrating a SQL application from an old Win2k cluster to some new
hardware.
The new hardware will run as a Win2K3SP1 cluster.
The App people would like to keep the names the same for all servers and

Is it possible to have 4 SQL instances in Cluster on 2 windows server.
Active/passive set-up.
In detail, what i mean is:
I have 2 windows OS - WinClustA with WinClustB

I am new to SQL server so any guidance is much appreciated.
We have two logical drives for our SQL server.We are upgrading from a
smaller driver to a bigger one. We have copied everything from one drive to
the other after doing so we decided the easiest thing to do would be to

I seem to understand the terminology of failover clustering as well as the
sibgle/mulple instance installations but it seems it does take about 2min for
a node to take over etc. I also red about log shipping and transactional
replication... Is there a way to load balance that can ...

  I'm curious if any of you are running Dell's rebranded EMC CX line of
storage enclosures and if so, what your experiences with them have been.
  Also, any experiences with their Fibre Channel offerings would be greatly
appreciated.  Thanks.

I'm working on a performance problem on a SQL server 2000 W2K SP4
Active / Active cluster.  The primary database (bigdb) is 140 Gb and
has 1200 users.  Looking at perfmon I am suspecting an I/O bottleneck.
The 8 CPUs in the system run all under 50%, and the 4 Gb RAM shows

Dear, I am needing to grant tolerance to shortcomings to a Server
SQL. The consultation is the following one, in Windows 2003 can have up to 8
nodes
in a Cluster, in my Cluster at the moment have two instances of SQL, it is