I recently added an additional node to a 2 node cluster hopeing to achieve N+1
I am running win2k3SP1, SQL2000SP3.
I can fail over clustering and MSDTC to the new node, but am unable to get
the existing virtual SQL servers to fail over to my new node.

I have a few existing 2000 instances that we are migrating to 2005 SP2.  The
instances have a lot of databases on them.  Is there an easy way to generate
the attach scripts for migrating?

I am trying to add 2 2005 nodes to an existing cluster that has 2xSQL2000
nodes. The cluster is using a SAN with - T, U drives as data and log in node
1, and - V, W drives as data and log in node 2
I want to add SQL2005 nodes, using these drives. When I start the install -

I hope this is the right place for my questions.
I would like to know whether there is a possibility to make available the
same data on two(or more) different instances of the database server, each
instance installed on a different computer.

You guys just posted that there is no true Scale Out technology with SS.  But
I am curious:  does MS have anything in the works?  Are there any rumors?
I'm wondering because I get Unix and Oracle guys constantly telling me that
Windows can't scale out because of inherent file and ...

I've been reading my Sql Server 2005 Maintenance and Implementation book on
Mirroring and Michael Hotek gives an example of a client that required
99.995% availability as well as zero data loss except in the event of a
natural disaster.  They also required automatic failover and ...

Just hoping that someone could shed some light on something strange with
profiler.
I'm doing some performance and bottleneck testing of a new app that uses a
SQL Server 2005 SP2 cluster on the backend. When I run a trace against the

I plan to create a cluster with 2 nodes.
i will configure a virtual server name and ip for the public client access.
is it possible to define a second name and ip for the virtual server an to
bind it to a seperate LAN interface?

How to tell sql server the maximum size my temptable will grow so that it
does at most 1 memory allocation?

We are looking into implementing an Active:Passive SQL 2005 Cluster for a
reasonably large and important system (< 1Tb)
I'm not looking for advice re: particular brand etc., but on advice on type
/ type of connection to SAN that may be appropriate. The SQL 2005 instance(s)

I have SQL 2005 server (with Named Instance) running on a two node Cluster
Configuration (Active/Passive).
SQL Instance, SQL Server Agent, SQL Server Browser services are running
under a service account (domain account). Similarly Cluster service is also

I will setup a 2 node sql 2005 std. ed cluster with multi instance.
How maney instance can i run (16 total in standard ed.) ?, there is a small
base with low traffic inside each instance.
Witch instance name & virtual name shoud i use SQLINST01\SQLINST01 or can i

Hello,I have a two node cluster with 64 bit sql server 2005 .
I am having a hard time finding any information on an error I am receiving
from attempting to connect 2 SQL Server 2005 servers  linked server. I
am setting the linked server to use the credentials of a SQL Server login.

I have a two node cluster, and need to add a third node, can anyone please
send me a link, or steps on howto.
url:http://www.ureader.com/gp/1142-1.aspx

Sorry for the repost... thought it better to put in a message of its own...
We have installed SSIS in a cluster.
We have a test package setup, however when we go into the properties for the package, go into Steps and on the General tab, under Server: we enter the Server Name, the ...