3.6.0 MxDB for SQL Server Installation and Administration Guide (5697-7088, December 2007)

Chapter 5: Configuration and Operation 57

the Virtual SQL Server fails over to a backup node, the ClusterPulse

process watches the health of the nodes higher in the list of servers for

that Virtual SQL Server. When the health of one of these nodes is equal

to or greater than the backup node where the Virtual SQL Server

currently resides, the Virtual SQL Server will automatically attempt to

fail back to that node.

•

NOFAILBACK. This policy is intended to minimize failovers and is the

default. The Virtual SQL Server remains active on the backup node

until a “healthier” node becomes available, at which point the Virtual

SQL Server fails over to that node. (On a “healthier” node, more of the

services associated with the Virtual SQL Server will be up than on the

node currently hosting the Virtual SQL Server. “Up” includes the

probe statuses UP and Standby.)

Network Interfaces Available/Members: Move the interfaces on which

the Virtual SQL Server should be configured from the Available column

to the Members column. The first interface that you select is the primary

interface. The other interfaces that you select are backups. You can use the

up and down arrows to reorder the interfaces on the Members column.

NOTE: When you modify the configuration of an existing Virtual SQL

Server, you can move interfaces between the Available and

Members columns, in effect changing the interfaces on which the

Virtual SQL Server is configured. However, you cannot move the

interface on which the Virtual SQL Server is currently active from

the Members column to the Available column.

When you click OK, a progress report will display the tasks required to

create the Virtual SQL Server. Click “Do it” to start the operation.

The new Virtual SQL Server appears on the Servers, Virtual Hosts, and

Applications tabs of the PolyServe Management Console. The following

example shows two Virtual SQL Servers configured on the servers in the

matrix.