I have a windows 2008 cluster configured and also have the SQL server and
the SQL server agent service configured inside the cluster.
In the services tab I have made these services manual and are configured
under a dedicated domain service account.

We have had a working SQL Server 2000 SP3 (default instance) on two node MS
Windows 2000 Advanced Server with MS Cluster servcie working for over a year
now.
The shared Q: and E: drives are actually two seperate LUNS from a SAN

The installation is progressing, however, it's failing in new and
exciting ways. I'm encountering two different errors in my System
Event Log:
Cluster resource 'SQL Network Name (XXXXXXX)' in clustered service or

I wonder if my interpretation of the "offline" status given (in
diskmgmt.msc) to  a drive just added to a W2K8-based SQL cluster is correct.
Let's say I allocate a brand spankin' new drive on my SAN and present it
simultaneously to the nodes.  I note right away that it's in ...

I'm trying to setup a SQL 2008 Cluster on a Windows 2008 Failover
Cluster. I'm going through the SQL Server Failover Cluster instance
setup wizard. I make it to the Instance Configuration screen. I've
entered SQL2K8_Cluster into the SQL Server Network Name field. I've

I wonder if my interpretation of the "offline" status given (in
diskmgmt.msc) to  a drive just added to a W2K8-based SQL cluster is correct.
Let's say I allocate a brand spankin' new drive on my SAN and present it
simultaneously to the nodes.  I note right away that it's in ...

Hello Everyone,
I'm trying to setup a 2 node SQL 2008 failover cluster in windows 2008 (2
instances).
After reading some documentation, I'm confused about the right path to follow.

I got the following error below while trying to take my database ofline
Error occurred while attempting to drop worktable with partition ID
171518519279616 and
Unable to drop worktable with partition ID 173615678750720 after repeated

I am having two instance in a SQL 2008 / Win 2008. In this case do I have to
have two MSDTC resource groups in the cluster?
Thanks,
Gunter

My company will buy 2 servers + 1cluster for storage SQL.
I need buy SQL 2008 standard or enterprise edition suitable for cluster?
Thanks!

I'm kind of planning to transfer databases from server1\instance1  (on
cluster-a) to server2\intance1 (on cluster-b) by detaching them from
server1\instance1 and copying to server2\instance2?  Or maybe backing them
up to server2\instance from server1\instance1.

I am trying to setup a SQL 2005 SP2 mirroring with auto failover. I need a
witness server for such configuration. Is the witness server a didicated
server for the mirorring set or I can use another stand alone SQL 2005 SP2
production server as a  witness server (shared as a ...