My database is 1gig big and it has so far one table with 1 melion records.
Once I tried to create the primary key in this table but it was rejected by
MS SQL since it was not unique. That's fine with me but I noticed that my
database doubled in size to just over 2 gigs. Then I ...

I am running SQL2000 (SP3 applied) on a cluster running in Windows
2003.
I have 2 problems: I am either unable to run a backup from a
maintenance plan, or I am unable to failover to the other server.

We currently have two W2K Enterprise servers running MSCS and each of these
is running MS SQL2000 enterprise.
The Cluster is Active/Active and we have a single instance of SQL running on
each server.

Is there a documentation on how to rebuild one node of an active/passaive SQL
Server cluster from the O/S up with the SQL Server in use by the other node?

Is it possible to deny access to local NT administrator
and one specific domain user on sql server cluster? The
cluster runs under domain user account with adminstrator
privileges on the local machine, I have another domain

I've read and heard some conflicting information about the best method for
setting up a MSDTC resource in a cluster.  I am running MSSQL 2000 SP3a and
Windows 2003.  2 node cluster with currently only once instance of MSSQL
with a great chance of growing.

i need to install sql 2000 cluster on win 2003.
i have all the maluals but something is not clear for me .
do i need to install MSDTC   before !!!    the sql set up via comclust.exe
on each node (like i wrote the OS is win2k3)

I have cluster with 2 nodes (sql 2000 on win 2003 ) and i want to install
active/passive configuration .
for that configuration for my understanding i need named instanced let say
SQLPROD and my vitual server name

I am a newbie to Clustering so please bear with me.
We have a db environment set up with Win 2003 and SQL 2000 connecting to a
single disk array.
The question I have is, what is the difference between the Cluster IP

Problem
Full-text indexing option is greyed out in the enterprise manager.
Setup
SQL2000 sp3a running on windows 2003 cluster. (Default install with SQL

I have read most the articles and posts about move sql server.
Here is my situation:
I have stand alone standard sql server 2000 and with about 40 databases. And
I am moving the server to a SQL cluster(Active/passive). I have to use the

We are in the process of implementing a SQL server and are thinking about a
SQL cluster on Windows 2003 Enterprise Edition Servers. But money is
preventing us buying extra hardware at this moment.
Is it possible to install first an SQL server with all the databases and

Platform:
Windows 2003 ent ed, SQL Server 2000 sp3a enterprise
We tried to bcp file into our Failover Cluster SQL Server database, but with
serious error:

If I want to put one server in one datacenter and the other server in another
datacenter what are the limitations of the heartbeat?

I have a Dell PE6650 with only 5 drives(15k). what is the best raid
configuation i can acheive for higest performace with this amount of drives.
I was thinking or either of the following
Option 1 ---------------------------