Rebooting a Cluster
Thu, 10 Jul 2008 12:59:06 -0700
Quick and easy question.
What is the proper procedure to shutdown a 4 node active SQL cluster. I
need to bring the servers down for disaster recovery testing. Should I
failover resources from all nodes to one and then shutdown those nodes and
then shutdown the last server? Or should I pause the each node ...
|
July Security Update for SQL 2005 Cluster
Thu, 10 Jul 2008 07:23:02 -0700
Hi,
I am trying to apply the new security update for sql server 2005. I have a
2-node active/passive cluster. How do I go about it? Should I take the
cluster down and apply it one node at a time to both nodes?
Thanks in advance,
--
Yuhong ...
|
SKUUPGRADE on SQL Server Cluster
Wed, 2 Jul 2008 07:07:03 -0700
The Company I am working for have inadvertantly installed SQL Server 2005
Developer edition instead of Standard edition onto a production cluster
solution.
the question is:
Is it sound to run setup with the SKUUPGRADE option to convert the current
developer edition to that of standard for a SQL Server ...
|
SQL Server Perfromace objects are missing from the System Performa
Wed, 2 Jul 2008 07:05:00 -0700
Hi,
I am trying to run System Performance tool to get statistic for my SQL
Server performance. Below are the environment configurations ---
OS- Windows Server 2003 Enterprise Edition x64 bit
SQL Server - Active - Active cluster
Node 1 - Default SQL Server 2000 Enterprise Edition with SP4 (Node 1 is
pr ...
|
Moving system datbases on cluster
Wed, 2 Jul 2008 03:57:01 -0700
I am just determining the necessary steps to move the system datbases that I
have on an Active/Passive cluster. I found the process to do this on a
standalone SQL Server.
What I don't know how to do is start SQL Server with the /f and /T3608. In
the process I have found it says you can just use NET START ...
|
Newbie in Clustering
Tue, 1 Jul 2008 08:57:04 -0700
I have two servers. On the first server I want to put two dbs and on to the
second second server I want to put the third db.
The dbs on the first server will be queried from 600 users. The high
performance is an important goal, and the high data availability, also.
I think to install two SQL Server instances o ...
|
Anything but McAfee
Tue, 01 Jul 2008 05:20:32 -0700
We have had nothing but problems on our clusters since installing McAfee HIP. Stay away from it! ...
|
|
|
Network load-balancing for active-active clusters
Thu, 26 Jun 2008 23:09:00 -0700
Hi,
I have a requirements to deploy SQL 2005 clustering as active/active nodes.
We also want to achieve load-balancing. For example, when there are 100 users
login to the clusters SQL, the request will split 50 / 50 to each of the sql
active node. Can it work in this way?
thanks if u could shed some lights ...
|
Number of nodes for sql clustering
Thu, 26 Jun 2008 23:05:00 -0700
Hi,
i understand that the technology for clustering are N+1 or N+m. However, Can
1 deploy sql cluster nodes in odd numbers? Example, 3 nodes with
active/active/passive or 5 nodes with 3 active/2 passive ??
Many thanks!!
regards,
Windows Fan ...
|
SQL 2005 and Win2008 Multi-subnet clustering
Mon, 23 Jun 2008 12:03:18 -0500
Is this supported?
Details:
2-node Win2008 Ent. Cluster with multiple subnets. Able to successfully fail
back and forth no problem with one subnet coming online at one node and the
other coming online at the other node.
Install SQL 2005 Ent. and it won't come online with the non-active subnet
configur ...
|
