3 node Cluster Question

Is it possible to have a node that is running one default and one named
instance of SQL Server 2000, A second node that's running a default instance
of sql server 2000 and have both failover to a third node? Any thoughts,
suggestions, or answers would eb appreciated particular if your're currently
running this conifiguration.
You only get one default instance per cluster. You can use DNS to alias an
old server name to the new server name. Three node clusters are legal using
Windows Server 2003 Enterprise Edition and SQL Server 2000 Enterprise
Edition. You can control the failover path for each instance independantly.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Roger Newton" <RogerNewton@.discussions.microsoft.com> wrote in message
news:257A442B-6027-4C21-A29E-A51C05C65E8D@.microsoft.com...
> Is it possible to have a node that is running one default and one named
> instance of SQL Server 2000, A second node that's running a default
instance
> of sql server 2000 and have both failover to a third node? Any thoughts,
> suggestions, or answers would eb appreciated particular if your're
currently
> running this conifiguration.
|||Thanks for responding,
So it sounds like that if I'm running windows 2003, SQL server 2000
enterprise have 1 default instance and 1 named instance on node A and 1 named
instance on node B I will be able to failover all instances to a third node
(node C) for failover purposes. Sound right to you?
"Geoff N. Hiten" wrote:

> You only get one default instance per cluster. You can use DNS to alias an
> old server name to the new server name. Three node clusters are legal using
> Windows Server 2003 Enterprise Edition and SQL Server 2000 Enterprise
> Edition. You can control the failover path for each instance independantly.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Roger Newton" <RogerNewton@.discussions.microsoft.com> wrote in message
> news:257A442B-6027-4C21-A29E-A51C05C65E8D@.microsoft.com...
> instance
> currently
>
>
|||You could look at it that way. Instances (default or named) don't really
have an owner node in SQL 2000. All nodes are equal, except during installs
or upgrades. You can set a preferred host order and limit which hosts are
allowed to run which instances, but you have to do that yourself after
setup. I personally run a N+1 cluster where I have three instances and four
nodes. My only gripe is I have to manually reset the preferred node order
if anybody fails over so I don't overcommit memory on a single node.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Roger Newton" <RogerNewton@.discussions.microsoft.com> wrote in message
news:C43C55D9-65E7-40FE-A4A5-4A3DC76EE9E3@.microsoft.com...
> Thanks for responding,
> So it sounds like that if I'm running windows 2003, SQL server 2000
> enterprise have 1 default instance and 1 named instance on node A and 1
named
> instance on node B I will be able to failover all instances to a third
node[vbcol=seagreen]
> (node C) for failover purposes. Sound right to you?
> "Geoff N. Hiten" wrote:
an[vbcol=seagreen]
using[vbcol=seagreen]
independantly.[vbcol=seagreen]
named[vbcol=seagreen]
thoughts,[vbcol=seagreen]
|||thanks for the help
"Geoff N. Hiten" wrote:

> You could look at it that way. Instances (default or named) don't really
> have an owner node in SQL 2000. All nodes are equal, except during installs
> or upgrades. You can set a preferred host order and limit which hosts are
> allowed to run which instances, but you have to do that yourself after
> setup. I personally run a N+1 cluster where I have three instances and four
> nodes. My only gripe is I have to manually reset the preferred node order
> if anybody fails over so I don't overcommit memory on a single node.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Roger Newton" <RogerNewton@.discussions.microsoft.com> wrote in message
> news:C43C55D9-65E7-40FE-A4A5-4A3DC76EE9E3@.microsoft.com...
> named
> node
> an
> using
> independantly.
> named
> thoughts,
>
>