Can I install more than one "named instances" on a vitual clustered SQL
Server2005?
If so, How can I?
MaDS

We've got SQL Server 2000 on a W2K3 2-node cluster, however its
starting to seem that the shared storage is unreliable/failing.  Is
there any way to drop the cluster to single node and then shunt the
database onto the local storage of that machine?  I've found posts

Hi everybody!. Sorry for my English skill. Can anyone help me how to
clustering sql server 2005 in Windows 2003 server? I had tried in Google but
I couldn't find any documentation
Thanks for all replies

I built a two server Windows 2003 cluster and installed two named
instances (SQL1 and SQL2) of SQL 2000 on virtual servers VSVR1 and
VSVR2.  I then renamed VSVR1 and VSVR2 to SQL1A and SQL2A respectively
using the Cluster admin to change the Network Names.

I'm looking for solution of minimizing downtime(amount of reboots) when
installing SP4 on 3-node cluster running 8 SQL2K instances.I anderstood from
readme file that after each instance installation boot of all nodes in a
cluster required.

Hi, Currently I am confronted with an issue to estimate how should we
organize or what should we buy in order to provide high availability and
efficient response times.
I have 3 different  DBs one which have high read activities, one has high

I'm new to SQL2005 so if this question is a stupid one please forgive me.
I have setup a clustered SQL2005 with a default instance.
This is working fine.
Now I want to add 3 more instances to my cluster.

Team:
I have a Cluster server in a SAN with Drive SAN drives attached to the
Cluster server, running SQL 2000.
I just added another drive volume H:\ as my backup drive to run all my SQL

We have 2 boxes running clustered windows enterprise OS 2003, SQL server 2000
sp4, also clustered.  Everything runs fine, except when we do a failover of
sql to the other node, full text indexing will not index.  The properties
come back with an item count of 1.  The only ...

Can anybody provide me with specific hardware and software requirements for
Two nodes SQL Server Cluster.
Thanks in advance.

I have set up my A/P cluster, and SQL 2005 sees my data partition of my RAID
for the data no problem.
How do I get to use my second partition of the RAID for my Log files?  Yes I
have a third partition for the Quorum.

We are installing SQL 2005 SP1 on a 2 node single instance windows 2003
cluster.  During the install I receive a box stating i have locked files.
The file is c:\program files\microsoft sql
server\90\shared\svrenumapi.dll(wmiprvse.exe).  I have read the KB article

We would like to apply SP1 to our Windows 2003 Enterprise Cluster server.
The Cluster server is on a SAN with an active/passive setup. The main service
running is SQL Server 2000 Enterprise. Is there anything that I need to know
from a DBA perspective?

I would like to find out if there are any free tools that could be used to
monitor a sql instance and list the
a. most frequently run stored procedures and how long each takes
b. most frequently run views and how long each takes

We have three live production SQL servers and one of them is nearing
capacity.  I have been asked to investigate SQL replication and there
is an understanding that SQL replication is the hold grail and it will
solve all of our problems.