Here is what we are trying to accomplish, and please let me know if we are
going down the right path.
We have 2 Windows 2000 Servers running SQL 2000 for a website.  The SQL
database is on one of the two servers and we want to create a redundant

Windows 2003 SP1   SQL 2000 SP3a   active/passive cluster     24x7 cluster
used by customer facing apps.  
Added a new node to the cluster and failed over.  Now my Full Text Indexes
on my database are gone.

How would I go about moving the system databases to a new drive? e.g. from
C: to G:? Thank you!

Hi I do not have any experience of clustered servers
I have some software that needs some dll's  placed into the directory below
which an extended strored proc uses to verify and run internal code.
C:\Program Files\Microsoft SQL Server\MSSQL<instancename>\Binn

Can I install SP2 for SQL2005 one instance. Is this affect other instances
in the same cluster server.
Thanks

If I need access rights to manage sql services(surface area config) in a
cluster server.
What kind rughts do I need? local admin?
Thanks

I inherited a SQL2005 cluster and while I'm experienced in managing SQL
stand alone I have no experience in a cluster environment. I am trying to
determine the cluster virtual server name, as opposed to instance, so I can
make changes to the service start up configurations. I can't ...

What is the maximum disk or SAN time-out a SQL-server cluster can handle?
Is this documented anywhere?
Regards

We have a 2003 clster with 2005 sql running across 2 nodes. We ran SP2
on the active node, all went through successfully, but it dodnt.
It left one node SQL SP2 and 1 Node SQL SP1
No every time i install the service pack on the sp1 node i get an

We have a 2003 clster with 2005 sql running across 2 nodes. We ran
SP2
on the active node, all went through successfully, but it dodnt.
It left one node SQL SP2 and 1 Node SQL SP1

We have a 2003 clster with 2005 sql running across 2 nodes. We ran
SP2
on the active node, all went through successfully, but it dodnt.
It left one node SQL SP2 and 1 Node SQL SP1

I had a very odd error occur over the weekend in a development
environment, and I want to see if you've ever heard of this or had
this happen.
Environment:

I've been struggling with this issue for a few days now.
We have 2node Server 2003 Entprise cluster with a fresh install of
MSSQL 2000 SP3a. Everything works great until I attempt to simluate a
node failure. Node 2 starts every service fine with the exception of

I have recently been given a cluster of 2 * DL580s with Windows 2003 sp1
installed. I installed a SQL2005 sp1 virtual server and instance on Server1,
and then a similar install on Server2. DTC is a separate group, with its own
disk, network name and IP address; the Cluster group ...

I have a two node cluster with SQL Server 2005 that I am having difficulty
getting AWE to work.  I have granted the "lock pages in memory" right to the
domain account that the SQL Server service is running under on both nodes
and run the following commands to setup the AWE memory ...