Preferred Nodes in a SQL 200 Cluster

#1

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?

#2

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" <robin9876 (AT) hotmail (DOT) com> wrote

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?

#3

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" <robin9876 (AT) hotmail (DOT) com> wrote

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?

#4

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" <robin9876 (AT) hotmail (DOT) com> wrote

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?

#5

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" <robin9876 (AT) hotmail (DOT) com> wrote

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?

#6

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" <robin9876 (AT) hotmail (DOT) com> wrote

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?

#7

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" <robin9876 (AT) hotmail (DOT) com> wrote

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?

#8

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" <robin9876 (AT) hotmail (DOT) com> wrote

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?

#9

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" <robin9876 (AT) hotmail (DOT) com> wrote

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?

#10

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" <robin9876 (AT) hotmail (DOT) com> wrote

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?