We have 2 servers running SQL 2000 Enterprise Edition SP3 in
Active/Passive configuration with 12GB of memory. We have allocated 7GB using
AWE enabled for sql with 5GB remaining for the OS and future instance. My
question is, we are trying to move to an Active/Active ...

Can DAS be used as shared external storage for SQL Server clustering?
Thanks in advance,
Leila

We have an Active/Passive SQL 2005 Cluster running on Windows 2003 Server
We have a website using a SQL database backend and have just started to
receive the following error
All schedulers on Node 0 appear deadlocked due to a large number of worker

Why would one use Veritas Clustering over SQL Clustering ?
Do let me know the pros and cons.
Thanks

I had an Access Database that I "upsized" to SQL Sever 2000 running on
Windows 2000 Advanced Server. The Access database tables are now inked
tables to the Sql server and all is fine. Users are able to update
data.

When I try to start my mirror,
I get the following error:  My mirror server db changes from "restoring.."
to "in recovery"...
But thats about it.  I have been following along, I restore the database,

Can the mirror server also host principal databases?   So, two servers,
mirroring to each other, but then if one fails, the other takes the full
load and becomes the principal for all databases?
Dennis

We are interested in a clustered/high-availability SQL 2005 system.
Basically, we have two physical servers we wish to dedicate to this.  Each
has their own drives, neither are fancy, (P4 3.0 gig with 2 gig RAM and SATA
HDs), but we would like to prevent as much down time.

sql 2005 sp1 has been released officially?

I have a standard "3 Active + 1 Standby" SQL 2000 SP3a cluster
configuration. There are three named instances on each node. The data and log
files are on SAN storage.
Lets say the setup is as follows: SQLP1, SQLP2, SQLP3 & SQLP4 are the

I have a two-node SQL Server 2000 cluster running on Windows 2003 SP1.
I have two named instances running in active/passive mode.  I have the
cluster resources set up in 4 groups.  The first group contains the
cluster resources (cluster name, cluster ip, and the quorum disk), the

I have recently setup an active/active SQL cluster and am wondering what is
the best way to reboot the 2 node cluster.
If I do a rolling reboot I will dissrupt the connection to the SQL server 2
times (once when the DB rolls off server A, and once when it rolls back onto

Is there anyone that has experience with AMD dual core on SQL 2005 cluster?
Thanks

I would appreciate if someone can give some advice on hardware for building
up SQL 2005 cluster. We will have 4 database of 50 GB each. How many
processors, memory,... do I need? My preference is to go for HP servers
Thanks in advance

OK hopefully an easy question for the experts.
We are currently trying to design/test implement an SQL Solution to use DB
Mirroring with SQL 2005 Ent.
We have successfully built an SQL Cluster with 05' Ent SP1 x 64 on with