Preferred Nodes in a SQL 200 Cluster

#51

No impact regardless it's SQL2000 or SQL2005.

Linchi

"Robin9876" wrote:

Quote:

So for a SQL 2000 cluster which has 2 nodes (both nodes are identical
hardware specifications) putting both of the servers as preferred node
would not have any affect on failover or other functionality?

On 6 Jun, 02:36, Linchi Shea <LinchiS... (AT) discussions (DOT) microsoft.com
wrote:
As Russ mentioned, the configuration of a 'preferred node' has no impact on
the failover behavior. I basically use it for documentation purposes.
Especially when you have multiple instances in a cluster, it's good to have
some means to tell which node an instance is supposed to run on. For
instance, when you have done some maintenance moving the instances around,
you better move them back to their nodes.

Linchi

"Tom Moreau" wrote:
It increases the availability of your SQL Server. If you have only one
preferred node, then it can run only on that node and when the node goes
down, you're off the air.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau

"Robin9876" <robin9... (AT) hotmail (DOT) com> wrote in message
news:ef2eed7f-2366-4f91-ac28-e8ae063cc16f (AT) k37g2000hsf (DOT) googlegroups.com...
On a Windows 2003 cluster that has SQL 2000 that has only one node in
the preferred nodes.

What is the implications of adding all the other nodes in the cluster?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Preferred Nodes in a SQL 200 Cluster

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering

Re: Preferred Nodes in a SQL 200 Cluster - 06-07-2008 , 10:24 PM