Archived Months
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
all groups > sql server clustering > june 2005 > threads for june 22 - 28, 2005

Filter by week: 1 2 3 4 5

Removing a SQL cluster node
Posted by Karl at 6/28/2005 5:45:26 PM
Could someone point me to some documentation on the best way to remove a node from a SQL cluster. It's a two node, two instance cluster, and I plan to rebuild one node, fail to the rebuilt one, then rebuild the remaining node. -Karl ...more >>


Transaction log with huge proportions
Posted by francisco - Portugal at 6/28/2005 11:12:02 AM
Hi all My SQL Cluster, has a database with 13Gb, but the transaction log is huge. I already stopped the file from gowing more then it it's but is there a way of reduce this file?)already try to shrink the file without sucess). Can i for instance, detach the database an start it with a new l...more >>

Transation deadlock on cluster environment
Posted by Kevin Yu at 6/28/2005 8:38:00 AM
hi all got a situation here, there are 3 app server that are running a same application to delete records in the sql server periodically. what happen is that they all start up at the same time to delete records on the same table.(this could be fixed by varying the start up time on each app s...more >>

What causes a SQL Cluster to Failover?
Posted by tjhazel at 6/28/2005 8:34:05 AM
What causes SQL Server to fail from the active node other than the heartbeat flat-lining? I have the cluster installed and tested the heartbeat by unplugging the active machine. Failover works great. My question is what else can cause the failover? Lets say we have a memory leak. Is t...more >>

Network Name and Kerberos Auth!
Posted by Mark Harris at 6/27/2005 2:04:01 AM
Dear all Firstly, please note that this is PURELY a Clustering / Active Directory question and nothing to do with SQL Server ... there just wasn't any other clustering newsgroups around!! Anyway, we have as Server2003 Cluster and i'm trying to setup a group that has a Network Name Resour...more >>

Single Node Cluster Upgrade
Posted by Inspiron9300 at 6/24/2005 12:53:49 PM
We have a SQL 2k Single Node Cluster that we are adding a Passive node to. We have installed everything but are having issues installing SP3a on the Passive node. The Active Node has SP3a already installed. We get an error stating "All cluster disks available to this virtual server are owned by ...more >>

Changing port numbers
Posted by zach_john at 6/23/2005 10:22:04 AM
On an active/active cluster what is the proper way of changing the port # on the named instance after an install is complete and in use. ...more >>

cluster manager and sql authentication
Posted by Neil W. at 6/23/2005 12:00:00 AM
I am a newbie to clustering so I hope this makes sense. Does the Cluster Manager have to be in the sysadmin role? If not, what are the roles that it does require? Thanks for any guidance. Neil ...more >>



Issues with moving existing single production server setup to a New Cluster installation
Posted by GMG at 6/23/2005 12:00:00 AM
According to the documentation the chosen Cluster name and IP address need to be unused before installing the cluster. The IP address is not a problem, but it will be a difficult task with the Cluster Name as the business processes have many scripts, DTS packages, stored procedures and views that...more >>

SQL load balancing
Posted by Francois Malgreve at 6/23/2005 12:00:00 AM
Hi all, We are afraid to start to hit the limit of the capacity on our production server and we are starting to think about scalability. We would like to scale out SQL Server and I wonder if it is possible to load balance SQL server. Is there any third paty software able to do that? It seem...more >>

Named Instances
Posted by Arun at 6/22/2005 6:45:01 PM
In SQL 2000 Clustering, can I have only one default instance for the entire cluster or can I have one default per virtual server. In other words, can all my SQL installs in a cluster be default, each on a different virtual server? ...more >>

cluster hardware - CPU, memory
Posted by Pari at 6/22/2005 7:57:16 AM
1. In MSCS and SQL Server 2-node clustering on windows 2000 advance server, are there any restrictions on the hardware. That is, do the 2 nodes necessarily should have the same number of CPU and memory? 2. when we have 2 node with sql server in cluster, can we install another non-clustered ...more >>

SSPI error
Posted by yba02 at 6/22/2005 7:31:07 AM
Hi, SQL 2K EE is running on a 2-node cluster. All was fine. Suddenly, node 2 owned the cluster group and now SQL is running on node 2. The reason is the problem: One node 1, SQL service is not starting and the MMC SQL snap-in returns "Cannot generate SSPI context" error when trying to conne...more >>


DevelopmentNow Blog