Trying to monitor NT event viewer for cluster failover events...
Can anyone suggest event IDs to watch for that SQL 2000 failes over one
to the other....
TIA

Does SQL Server require the /3GB boot.ini switch on a /PAE on a 16gb Win 2003
Server?  What will happen if you don't?
I know you do not use the /3GB when memory is over 16gb (With PAE...).
Thanks...

we have installed SQL 2005 on a two node Windows Server 2003 cluster. the
cluster is configured with two instances, each using it's own resource group
(virtual name , IP address, physical disk).
the first instance is installed as the default instance

I have had some new SAN LUNS made available to add to my SQL 2000 failover
Cluster (two nodes) running on Windows 2000 Advanced Server. They were put
in some time ago and have been showing in the Windows Disk Management list.
They were in a virgin state with no signature and ...

I have an SQL Enterprise 2005 Cluster that should have been setup as 2005
Standard Cluster.  Mainly for licensing and $$ reasons I need to convert
this.  It is running on Win2K3 with just some small production databases on
it (not heavy use). I am not using any special features ...

My partner Loren had raised a question yesterday about some services only
being installed on the active side of an SQL2005 cluster at setup.
We are using clusters for development/acceptance and production. What is the
effect of say SSIS only being installed on one node of an ...

I have a question about what happens in the event that the cluster
completely breaks (whatever this may mean) - is it possible to get
SQL Server up and running on just one box? I realize that this is an
overly simplified question, and that many factors could be involved.

What are cons for placing both stage and production versions of the same db
on our only "real" cluster?  4 cpu / 4 gig ram dell server.
We have heavy batch work where we prepare data for submission to another
process, so there is a ton of munge work in the batches for 2+ hr ...

I am planning to upgrade my sql 2000 32 bit to  sql 2005 on new cluster
hardware.
shall i go for 32 bit or 64 bit ?
my application is a critical OLTP application with DB size around 10 gb and

I am trying to get people's opinions, experience, etc with SQL Server
2005 clustering ?
We are making some critical business decisions this morning about
whether or not to move ahead with our plan to use clustering...

Well - first TIA!
We have an Active/Passive cluster running W2K3 Enterprise X64 Sp1, 32GB RAM
and SQL Server 2005. We're moving to a N+1 configuration (and then maybe N+M
later), but I'm running into an error.

Anyone having a clue to what can be wrong??
The installer returns the mesage:
Setup failed to start on the remote machine. Check the task scheduler event
log on the remote machine.

How do we figure out Primary and Secondary Node for a active-passive
clustering setup on SQL server 2000. Are there any simple and straight
commands to find them?

I am have installed a single-node sql server 200 cluster on windows 2003
(SP1).
The SQL Server resource is not starting if MSDTC is configured as a cluster
resource.

I have a cluster A/P 4 processor 4 gig of ram with 3 gig allocated to SQL
server.  I have put on the same cluster my testing of 2005 and will switch
over soon.
How does SQL Server deal with RAM between the 2 instances?