Suppose I have SERVER1 and SERVER2 with database DB1 and DB2 in both servers
with database mirroring enabled for both databases.
If I'm connected to Server1 and execute something like this: "SELECT * FROM
DB2..MyTable":

I want to have 3 MSSQL server that work at same time on shared
database(all opened a single data file on SAN for example). And request
for queries are send to those parallel and same sql servers to archive
more processing power and fail over feature?act as load balancing?

Our env: SQL Server 2005 Ent SP2 64-bit, two-node single-instance failover
cluster, Win2003 Ent SP1, 16GB
Here's our problem: The startup parameters were modified using SQL Cong Mgr
by adding a -T1118 at end (recommended when doing tempdb striping).  We keep

I am installing sql 2005 on a two node cluster. I have managed to complete
the installation and then wanted to add the sql management studio on to the
cluster. I installed disk two and chose the support tools but have way
through the installation it failed with the following ...

I am about to install sql 2005 in a clustered scenario. I am reading the
installation notes and it says :
On the Cluster Group Selection page, select the group that contains the
drive you want to use for SQL Server from the Available Cluster Groups. The

Im working on sql consolidation project and I am about to build multiinstance
2 node cluster.
If I want Integration services installed should I manually install on both
nodes or thats something that will be installed automatically on both nodes (

How can we convert our SQL Server 2000 (Windows Server 2003 R2)
Active\Passive cluster to Active\Active?
Thank you.

I have an active/passive SQL 2005 cluster consisting of 2 nodes. My bosses
want me to rename both nodes and also move the cluster to a new domain. How
would I do that ?.
Regards

If I configure a director-class SAN with RAID 10 for the actual storage with
enough and more space, is it safe to assume that I can store all database
files (primary and secondary) and log files on the same logical drive exposed
by the SAN and have SQL Server 2005/2008 perform ...

We have a consultant setting up a SQL 2005 Cluster.  This person is asking
for a temporary domain administrator account for the installation.  He says
it is needed for setting up Notification Services.  I can't find anything in
the documentation that says this is needed.  Has ...

Despite being directly connected with a crossover cable and each server
being connected in to the switch, they seem to think that they need to
failover when the switch goes off line.  Why?
Surely they should only be checking connectivity if the heartbeat fails over

I'm trying to install SQL 2005 on a Windows 2008 cluster. I just want
to know if this is supported, and if there's any special procedures
required for the same.
Thanks

oops, post should have gone to this forum .....
Hi,
I read in the SQL 2005 Exam guides for clustering that (p.283 - 70-443),
that if building a cluster on 64-bit Windows then must use Fibre drives?

I have a SQL 2000 2-node cluster that is working fine.  In a few days they
will be changing the networking on the network where this cluster is located.
I will need to change the subnet mask from 255.255.255.0 to 255.255.254.0.  
I don't need to change the IP address of the ...

SQL Server 2000, Windows 2003 R2, Cluster 5.2
We're setting up a new cluster and I would like to move the LOGFILE and
SQLAGENT.OUT file off of the drive(s) that contain .ldf & .mdf files. My
reason is that these files will contribute to drive fragmentation (also, I