I've assigned to suggest proposing a solution in which the stakeholders are
interested in having their SQL upgrade from 2000 to 2008. They would also
like to have their clusters (2 different clusters) be Active / Active with
the 2nd one have transactional replication from the 1st ...

We have set up failover clustering for our production servers. but we are
facing a strange issue when the web application servers try to connect to
slqserver when its failed over.
We are experiencing connection time out. but once we restart our application

I am new to SQL clustering.  Does SQL 2008 clustering as far as functionality
remain the same as SQL 2005?   I am looking for any 'best practises for
setting up SQL clustering.    
For setting up windows 2008 clustering , I only found the step-by-step guide

i want to install an application using SQL 2005 server in two different
location where delays (Latency) in communication could be great. how can i
install the SQL 2005 on two different servers each with its own database and
having the two databases synchronize with each other ...

In a SQL 2005 cluster it is only one drive which is on the EVA
storage. There are three drives on the EVA and all the drives are
visible in windows explorer. All the SQL components are on this node.
What else can be checked to ensure that all the drives are visible?

I have one of my cluster nodes going into a reboot loop and I have narrowed
it down to the NIC on the public side.
I troubleshot into safe mode and it booted up fine so I would suspect it is
a piece oof hardware with an issue or a corrupt driver. Did all of the

Hi Guys, I have an issue on an MS 2008 cluster build. It is FC connected to
the SAN and can see all 3 LUNs presented x8 for the SAN controller channels.
So in disk manager I can see 24 disks, of which I am using 3, the rest are
offline. I would like to remove the ghosted disk ...

I have a 2 node cluster with 2 instances of SQL 2000 SP4,  Node one failed
on the cluster and I had to reinstalled the OS.
I got the OS installed and the joined the existing cluster.  No problem
there.  The problem is I need to reinstall the SQL software on the newly

Hello SQL forum users,
We are facing the subjected error (Event ID: 17052 "Insufficient Memory
Available")
on Ms SQL 2000 Cluster at production site, which slows down SQL performance

Guys, do you know if i could test 2 node cluster installation and
configuration by using VM's?

i have installed two node cluster . and also configure MSDTC services on
cluster . but when i try to move group to other instance(failover) , it gets
failed by giving following error message in error log " MS DTC Transaction
Manager start failed. LogInit returned error 0xc000103a ...

Our failover cluster setup is as follows:
-2 nodes, each: 4 QuadCore CPUs (total of 16 shown in Task Mgr), 64 GB RAM
-Windows Server 2003 Enterprise x64 Edition, SP2
-single named instance: SQL Server 2005 64-bit, SP2

  We are currently looking at setting up 3-Node Cluster with
Active/Active/Passive configuration.  I am sorry clustering is my weakness
and I not very good at it, so if the question sounds wrong please let me know.
Configuration we are aiming for (Configuration A):

This is the first time I will be installing 2005 Sql Server in an
Active/Passive Cluster as a result I have a few questions.
1.The Server cluster I need to install SQL 2005 on is currently acting
a file server. It has two nodes in active/passive mode and one virtual

Hi All SQL Gurus
Here is my scenerio
I have a Win2003 SQL Server 2000 Cluster server.
Now the plan is to upgrade to SQL2005 But they do not want to upgrade the