all groups > sql server clustering > september 2004 > threads for september 29 - 30, 2004
Filter by week: 1 2 3 4 5
SP3a on new cluster nodes
Posted by Ken Jensen at 9/30/2004 5:47:01 PM
I have an existing, two-node Windows 2003 cluster running four instances of
SQL Server 2000, SP3a. I have two additional nodes that I now want to merge
into the cluster. I connected the existing cluster disks to the new servers.
I ran SQL2K setup and successfully laid down the binaries. I ... more >>
performance question - SQL2k sp3
Posted by wasnotwas at 9/30/2004 3:29:34 PM
We moved a large database & application from a single server with RAID
drives to a clustered server with a SAN and are not seeing any performance
gains. Statistics were updated, procs recompiled, etc. after the move. The
CPU load is lower (as seen in perfmon), and the SAN disks are also not
wo... more >>
Rebuild fulltext
Posted by peter.lindbergTAKE NO[at]SPAM AWAYmartinsson.se at 9/30/2004 12:54:10 PM
Hi!
I have a problem with a 4-node cluster. It was a 2-node sql2k on w2k.
We installed new hw with w2k3 and installed the old instances there
(restore). After that we added 2 more w2k3 nodes and installed the
original 2 instances on all 4 nodes. We also set up 2 new instances to
be a total of... more >>
Connectivity Issues
Posted by Fonkberry at 9/30/2004 12:23:14 PM
We’re having a problem with our web applications connecting to the SQL DB
virtual server cluster. We are running SQL 2000 an '03 Server Cluster. The
front-end web servers are Win2K, IIS 5. The web servers and the database
server reside on the same LAN and the front end can ping the backend u... more >>
Clustering SQL and service packs
Posted by Stephen Aldous at 9/30/2004 10:13:47 AM
I have a SQL 2000 cluster and have applied SP3 to it.
However, when running on one side of the cluster SQL reports a different
version to when it is running on the other side. Is this normal / expected
or has it not applied SP3 to the other node correctly?
e.g
Running on node 1
select @@ve... more >>
Instance name already exists
Posted by JJP at 9/29/2004 10:27:13 AM
Hello all...
Win2k3 enterprise
SQL 2000
2 nodes
I had 2 instances of SQL installed. I had to run setup to remove clustered
SQL so I could break the disk array and make it larger.
Now, I install instance 1 on node 1 just fine.
But when I run setup on node 2 to install instance 2, it tells... more >>
Cluster Crash when pull both cable out
Posted by David Liu at 9/29/2004 8:27:20 AM
I have setup a production sql server cluster, as ususall I
setup MSCS first and do the failover test.
I use dual fiber channel card for redundancy, but I meet
prob:
Broke one fiber connect. Passed it did not fail over
because it is redundant. Broke second fiber connection.
CLUSTER FAILE... more >>
|