Currently we have an ACTIVE/ACTIVE SQL Server 2000 cluster in our production
environment. The current configuration is such that each node has a dedicated
server hardware. Lets call one of the ACTIVE nodes as NODE1 and the other
ACTIVE node as NODE2. We are in the planning stages ...

Here is my problem:
I've having trouble to make my second logical drive available for database
under SQL server 2005 (Other words: I cannot move database to my second
database drive because I cannot see it in SQL server 2005)

I am administering a 2005 SQL active/passive cluster.
The sql services are all running under a domain logon that has "Domain
Admin" rights, and I'd like to change that.
According to http://support.microsoft.com/kb/915846/en-us, it seems that

I want to remove a node from my SQL Server Cluster using Add/Remove
Programs.  the SQL resource is on the node that is remaining.  Question:
When I do the actual removal of the node, will SQL stay on line on the other
node, or does it go offline for a short period of time?

We are planning on using Database Mirroring internally within the data
center for HA and since its used, I am left now with log shipping or
possibly some SAN replication.
I think either one will work with log shipping being very affordable.. Free

I just started at a new company and am looking at their active/active cluster
and immediatly saw that the CPU usage between the machines is very different.
When I asked why, they said the DB1 is on node 1 and DB2 is on node 2.
Duh.

I am also kind of new to clusteirng and there are some questons I have
regarding how to best setup storage in a clustered environment:
1. My client is planning to setup a 1+1 clustered environment attached to a
Hitachi AMS1000 SAN. We need to plan how to properly allocate around ...

I'm unable to add a Second node (Win2k3 SP1) to a currently existing SQL2005
Cluster .I'm using the Add/Remove Programs and I'm trying to add it back in
as another possible SQL Server owner .
If I select "change" with Add/Remove (on good node)it only gives me options

I've setup database mirroring in high safety mode with automatic failover
(with a witness) and the databases seem to be synchronising ok (I've failed
over a few times to test and all seems well). The only problem I have
however is that when I open up the Database Mirroring Monitor ...

We plan to retire two existing 2-node Prod clusters running Windows
2000 Ad and Windows 2003 respectively and hosting 4 SQL Server 2000
instances each, with one new 2-node cluster with latest hardware
running Windows 2003 SP2. We want to keep the same name and IPs for

This is not my expertise, so would appreciate some help.
Is it possible to create an active/passive failover setup or database
mirroring without a shared disk?    Client has two sql servers that they
wanted to upgrade SQL 2000 to SQL 2005 and then use the second box for an

I was reading the Microsoft white paper
(http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx) on clustering and noticed something I didn't expect.
It seems to say that only one node of a cluster may be used at a time and
that it is not for (any kind of) ...

I having a problem starting sql server in a cluster.  The error has the
description;
17113:
initconfig: Error 2(the system cannot find the file specified.) opening

I want to know how to install the JDBC XA driver in a cluster and make i
cluster aware.
Thanks,
Padron

our AD, say company.com, has clients with different DNS suffixes. E.g.
dc1.company.com
dc1.company.com
sql1.sub.company.com