What is MSDTC and why woud I want it on my W2K3 ent act/pas SQL 2K cluster?
Cluster is already setup and virtual sql instance running ok...
Thanks

Cluster active-active. The installation in one server was lost and the S.O.
was reinstalled. Now in one node there are two instances. How can I reinstall
de second node and move the instance to it ?

Environment:
HP Servers and SAN
Win2k3 EE (no SP1 but all WinUpdate patches)
SQL2k EE w/SP3a

Hi everydoby, i'm new in this ng :=)
I'm also new to cluster and i have little questions.
I have 2 node (identical, HP DL380) and a san MSA1500, redundant path FC,2
network card for private and public.SQL 2000 clustered.

I am in the process of building a SQL Server "farm," but having to tone down
the pace due to $$.  I have just purchased a RAID1 (2 disc/10K rpm/146 GB)
Channel 0, RAID5 (3 disc/10K rpm/146 GB) Channel 1 server with 2 CPU's.  This
summer, I plan to buy an identical machine.  They ...

I am trying to work out if it is ok to install an antivirus product onto my
Windows 2003 SQL Cluster.
According to Symantec I can:
http://service1.symantec.com/SUPPORT/ent-security ...

I have two physical SQL servers running under cluster.  When execute a
query that returns around 3000 records on one of the cluster node
machine, it comes back in 3 seconds but if execute the query from other
machine that to the virtual machine, it takes more than a minute.  The

I am planiing to install SQL 2000 EE on Win 2003 Cluster:
   2 node cluster, Windows 2003
   1 SQL Server instance (active/passive)
In order to do so I need some answers:

I have 2 2003 servers each running a separate copy of SQL.  I have purchased
a external storage Dell Powervault running RAID 5 to serve as the shared disk
space.  I would like to create a SQL cluster with these 2 machines.  Each SQL
server has databases that will need to be moved ...

Thanks a lot!
You helped me, but now I have a few more questions:
I am installing SQL Server 2000 cluster (1 instance) on Windows 2003 SP1
1. Do I really need WINS on the network? According to "SQL Server Failover

Can one deploy a 2 node cluster with an instance on each node and the
failover node be the other?  Like node A & node B, A's instance fails to B
and B's instance fails to A?  

This is probably a hardware issue, but since HP is of no help, I thought I'd
post here too.
We have a SQL/Exchange 2-node cluster(Windows 2003, Exchange 2003, & SQL
2000) attached to a SAN(MSA1000).  Drives are configured in RAID1+0, with a

Does merge replication support clustering?
I'm having some troubles about  merge agent "querytimeout" parameter
throught a clustered system, and the hints that are over there about
"increasing timeout", "refreshing indices" and a lot more don't give any

I do not have any experience with MS SQL. I'm a hardware engineer. I focus
mainly on the servers hardware and connectivity.
I was wondering, is it possible to cluster 2 (or more) nodes running all
nodes on active / active as a single MS SQL database system? The servers are

Hi, Could you help me modify the SELECT statement below that would
accomplish my final goal.
SELECT col1, col2 FROM table1 WHERE col3 < @V
In col1 rows have many duplicates