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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >>
|