Multiple instances in an active/passive or active/active scenario

Giganews Newsgroups
Subject: Multiple instances in an active/passive or active/active scenario
Posted by:  Carlo R (Carl…@discussions.microsoft.com)
Date: Sun, 6 Aug 2006

I know that from SQL Server 2K the terms active/active and active/passive
(that cames from SQL Server 7.0) are not really applicable anymore. But I can
always have also in SQL Server 2K and 2K5 (for example in a two-node failover
cluster configuration) an "active" machine and a "standby" one, or two
machine ruinning at the same time. My question is: can I have more that an
active SQL Server Instance on an active node in an active/passive
configuration, with both failovers on the second node in case of failure of
the first node (in SQL Server 2K / 2K5) ? In SQL Server 2K and 2K5 this is
named as "multiple-instance" also if I have only an active-node at a certain
time? And, in an active/active scenario, can also I have two instance on a
node and two different instances on a second node with 4 instances of a
single node in case of failure ? In my personal opinion can be useful
separate the concept of active-passive vs. active/active (from the point of
view of the "active" harware resources) from the concept of single instance
vs. multiple-instance. The documentation, in my personal opinion, should
separate the four different scenarios with AP + SingleInstance, AA +
SingleInstance, AP + MultiInstance, AA+MultiInstance. Best regards and many
thanks.

Replies