I am planning on a two node cluster with multiple
instances. I will have two databases and two separate
applications will be going against them. I want 'APP 1'
to go against 'DB 1' on 'NODE 1' and failover to 'NODE
2'. I want 'APP 2' to go against 'DB 2' on 'NODE 2' and
failover to 'NODE 1'.

Is this possible? Does that mean that I will have two
virtual servers?
Will I have one default instance and one named instance on
each node?

Comments Inline

--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com

I support the Professional Association for SQL Server
www.sqlpass.org

"Earl Spooner" <anonymous (AT) discussions (DOT) microsoft.com> wrote


instances. The instances are per cluster, not per node so you can only have
one default instance on a cluster. Each instance can live on one host node
at any given moment. You can choose the failover order. The outside world
sees each instance as a named instance of a SQL server.

Thanks so much on the quick reply

Hi Geoff,

Let me get this right. It is impossible to have an active/passive
cluster with, for example, 16 virtual servers without naming the
instance on each one of them, except one (the default). Is that right
? thank you

"Geoff N. Hiten" <SRDBA (AT) Careerbuilder (DOT) com> wrote

Correct, the term is Named Instance

Cheers,

Rod

"Patricia B." <patricia_bouisset (AT) homedepot (DOT) com> wrote