I have a cluster with 16 gb RAM on each server, one instance on each server
and no other applications on either server.  Do I set the max server memory
to 6 gig, 7 gig or  8 gig for each server?  I would think 7 gig, if I had a
failover I would have 7+7 +2 (for the OS).  Do I ...

I have SQL Server 2000 cluster this is Active/Active.
The server has total 4GB of RAM with Windows 2000 Advanced Server.
Should the /3GB be applied to the both Active/Active nodes?
I would like the primary node to get 2.8 GB and the secondary node to get

We are trying to backup a DB from a W2K3 Cluster running SQL2000Ent. the
following is the backup command from the created Job:
BACKUP DATABASE [NGProd] TO  DISK =
N'\\Mviparprtsrv01\NextGenRoot\DBBackup\NGProd_data_dump.bak' WITH  INIT ,  

I am trying to setup a MSDTC on Windows 2003 Cluster.
I have done the steps in Q301600 and KB 817064.
However the MSDTC Resource will start on one of the cluster nodes but not on
the other. (2 node cluster). I have checked that both nodes have access to

I have an application that uses com components to connect to it's backend sql
server db.  Right now the db is running on a W2k server (sp4)
(non-clustered).  I've copied the dbs to the clustered environment that we
are migrating all of our databases to, and now the com components ...

I am having some issues installing a second virtual server. The first VS
installed fine with no issues and has no issues operating. On the second VS
install, the install process makes it all the way through to the point where
it creates the cluster resources. But when it goes to ...

After running through all the pre-install questions, it begins by saying that
it is performing operations on the cluster nodes and then fails with the
message:
"The path specified in a command line argument is invalid:

This is my time to setup active/active SQL on two nodes cluster environment.
I am very familiar with active/passive in which setup one virtual name such
as virtualsql01 and publish to user. For active/active, it seems to me that
system does not allow me to have something like ...

Hi,
I am not able to install Reporting Services (RS) on a Web Farm, but would
like to get it installed and configured on a active/passive Failover Cluster.
What do you think about the following scenario?

I have a MS Distributed Transaction Coordinator qestion which doesnt involve
a clustered setup at all. I know this may not technically be the correct
forum but I've solved other MSDTC issues here before so I was hoping....!
Do you know whether any problems should be anticipated ...

   I have inherited 2 node active/passive SQL Server cluster. I have
noticed that SQL Server service is running on active node only. I was
wondering if this is normal behavior. In case of failover, will SQL Server
service start automatically on passive node? What will happen if ...

I am looking for some advice on the following problem.
I need a redundant SQL solution at our main location and a warm site in
a different, off site location.  The warm site would only become a hot
site if we had a complete failure at the main location.

I'm building, for learning purposes, a two-node SQL Server 2000 cluster
using VMWare; the guest OS is Windows Server 2003, SP1.
I managed to correctly configure VMWare to share some virtual disks between
two VMs, created a third VM to use as a domain controller, created the

When I install cluster SQL Server in two nodes (active-passive), I used
valid administrator account for all nodes. After install, I changed SQL Agent
service account for replicate database. SA asked me to change the SQL Server
service account to not using currently administrator ...

Is it possible to create a single node cluster? I want to have some test for
sql cluster, but I only have 1 computer available. a 2nd HD is installed on
the computer, i want to use it for quorum, is it feasible?
Thanks,