SQL 2005 Ent install on cluster
Fri, 5 Sep 2008 00:55:01 -0700
Hi All,
I am receiving this error when attempting to install SQL2K5 on the first
node of my cluster.
Setup
2 Node Failover cluster - connected via iSCSI.
Both Nodes are online and failover correctly when tested in about 3-5seconds
Have tried installing to node1 and node2 with each as active and solitary
...
|
BCV restore of sql server 2000 to 2005
Tue, 2 Sep 2008 12:46:01 -0700
Hi,
We have sql server 2000 cluster, with 4 (active-passive) instances. Shared
drives (all system and user databases) are EMC. Since databases are large
(~1TB), we take only BCV backups of shared volumes.
We are installing sql server 2005 cluster on the new set of servers. We plan
to restore shared drives ...
|
adding SQL2005 to an Existing SQL 200 cluster
Tue, 2 Sep 2008 11:31:02 -0700
from all the documentation i have read, i would need a separate set of
volumes to add a SQL2005 clustered instance to my clustered 2000 instance.
This seems rediculous, that i can't use the current volumes for this new
instance. Any comments???? ...
|
RS dbs on a new local instance or on a clustered instance
Mon, 1 Sep 2008 08:00:01 -0700
I need to install Reporting Services in a cluster environment.
I have two SQL Server clustered instances, each one uses 2 disks on a SAN
(one for data and the other one for log).
Is it better creating a new local SQL instance on each node or updating
each SQL Server clustered instance?
Thanks ...
|
Adding msdb folder in MsDtsSrvr.ini.xml for SSIS
Mon, 1 Sep 2008 07:28:01 -0700
I have installed SSIS 2005 in a two node cluster not as clustered resource.
In order to render available the SSIS package in a node to another node
I want to modify the MsDtsSrvr.ini.xml file.
Is it possible to specify a particular name for the SQL Server folder as
MSDBNode1 and not simply MSDB?
Thanks ...
|
Minimize failover time
Mon, 1 Sep 2008 07:23:00 -0700
I have a two node cluster (active/active).
When I try the failover with the cluster administrator tool I have seen that
it occurs 15-20 seconds to recover the SQL Server resource.
Is it possible to decrement the failover time for the SQL Server resource?
How?
Thanks ...
|
Which tcp port to assign to optimize failover cluster performance
Sat, 30 Aug 2008 22:50:00 -0700
In order to optimize failover cluster performance, I have read it is useful
to use a static port and not the dynamic port (e.g. 1433). To use a static
port, how I can determine which port number to fix?
Thanks ...
|
|
|
Installing SSIS 2005 in a clustered environment
Fri, 29 Aug 2008 07:20:00 -0700
I have a two node cluster (a/a) with two SQL Server instances.
Now, I have to plan to install SSIS, but not as cluster resource.
Each node have a local disk. Each SQL Server resource group have two
disk (one for the data and the other one for the transaction log) on a SAN.
I think to install SSIS on each node. D ...
|
SQL server Full text catalog problem
Fri, 29 Aug 2008 10:15:52 +0300
hello to everyone ,
We have in our company a two nodes active-passive cluster with SQL Server
2000 SP4.
Recently one of our customer required from us to create a full text
catalog for some tables & columns
for his database.
So we made it ,but we realise that Microsoft Search didn't work when ...
|
Looking for high performance cluster storage
Thu, 28 Aug 2008 13:00:22 -0700 (PDT)
I have a 2 node SQL 2005 cluster (active-passive) that currently has a
single direct attached SCSI array for it's shared storage. Because
we've reached the performance limit of the SCSI array, I want to
replace it with multiple SAS arrays connected to multiple controllers
to reduce contention. I like the Dell ...
|
