4.1.0 HP PolyServe Software for Microsoft SQL Server administration guide (T5392-96074, October 2010)

Active-Active
In this configuration, the nodes in the matrix back up each others’ Virtual SQL Servers.
In the following example, the Virtual SQL Server “virtual1” is primary on node1 and
has a backup on node2. The SQL instance “instance1” is associated with this virtual
server and exists on both nodes. Clients can access the virtual server using
virtual1\instance1.
Similarly, Virtual SQL Server “virtual2” is primary on node 2 and has a backup on
node1. Two instances (instance2 and instance3) are associated with this virtual server
and exist on both nodes.
Many-to-One
In this configuration, one node provides backups for the Virtual SQL Servers running
on the other nodes. In the following example, nodes 1, 2, and 3 are each hosting
a Virtual SQL Server. These virtual servers all use node 4 as a backup. The instances
associated with the Virtual SQL Servers are all installed on backup node 4.
The following configuration also has one node providing a backup for the Virtual
SQL Servers on other nodes. In this example, the SQL instances associated with the
Virtual SQL Servers all have the same name, “instance1.”
HP PolyServe Software for Microsoft SQL Server 4.1 administration guide 11