Here is question i got:
I have sql server 2005 failover clustering. On node1 someone has run
procedure which update data on huge table which take over 8 hours.
In this case I can't release the database (as far as i know) because if i

I am testing an active/passive cluster running W2003 and SQL 2005 SP2. What I
try to test is: Power down one node and then on the active node using
Add/Remove program to attempt to take that node out. According to what I read
from the Web and a book, this is a required step ...

Can someone give me an opinion with installing SQL Server 2005 with
clustering and use those servers for file servers at the same time.
Thanks
Jacques

...has anybody tried this? ...
I need to install the 10g client on a cluster virtual server so that I can
use integration services to pull data from oracle to sql. I have this
already running on non clustered servers.

I have sql 2005 installed with sp2. I have an external file server with 1
terribyte of space. I want to have my data and log files on the external
file server. I mounted and mapped the external server at S:\Data and T:\Logs.
However when I try to create a db it only lets me use ...

Can we use Majority Node Set to run SQL Clustering. If yes, Can anyone
provide me the step by step guide to do this.
Thanks
Neeraj Mehra

We have a 2 Node SQL Cluster that I was trying to upgrade to win2k3 from
win2k. In the process the  cluster got completely corrupted. I followed some
documentation online and did:
Cluster Node <name> /ForceCleanup

I perfectly well understand how to create a SQL 2005 cluster. So I
have a 2 node Cluster Active/Passive, on which i have SQL 2005
installed, with a quorum disk. Everything's fine.
Now, i have several others servers to install (Exchange, Moss, OCS),

I am in the process of upgrading our servers from win2k to win2k3 SP2. We
have a 2 node failover cluster services confg for sql2k. So while upgrading
one of the two nodes in the cluster, I ended up evicting the node that was
being upgraded. Now that I have the successfully ...

I have two Windows Server 2003 Enterprise servers configured to an basic
cluster.
I want to install SQL 2005 on this servers to get high avaiability for the
databases.

I am looking at putting the specs together for a new SQL Server 2005
cluster, two nodes. It needs to be capable of supporting multiple customer
databases, around 20-30, average database size is 3GB but several will be in
the region of 10-20GB, capable of handling 10,000 ...

I have a 2 node SQL 2005 cluster.  I have a few questions about the Quorum
resources.  When I setup the cluster I pointed the vitural server quorum
resource to a local disk. (Q:\MSCS).  I feel like I did not set this up
correctly.  The 4 Resources types I have in the First ...

I explain, I will have a 3 nodes cluster, all nodes will host 1 instance,
but I need that 2 of them get the same instance name. during the setup it
refuse, I don't understand why as each instance will have it's own virtual
server and the path will be different SERVERA\INS1 and ...

what is the best way to store passwords and credit card information in SQL
Server 2005?

I currently have active/passive SQL 2005 STD SP2 servers.  I have found some
differences between the settings when I failover between both SQL servers.  I
think that one of the DBA's made setting changes as well as created
maintenance plans while logged into the specific server ...