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

Chapter 5: Configuration and Operation 72

Manage MxDB for SQL Server

You can use the Applications tab to manage Virtual SQL Servers and the

associated virtual SQL instances. You can use “drag and drop” to make

changes, or you can right-click on the Virtual SQL Server or instance (in

the Name column) and then select the appropriate menu item.

“Drag and drop” operations for Virtual SQL Server and virtual SQL

instances work in the same manner as Matrix Server virtual hosts and

monitors. See the PolyServe Matrix Server Administration Guide for more

information.

Caution When Using Drag and Drop

When moving a Virtual SQL Server via drag and drop, be sure to avoid

creating a situation in which a Virtual SQL Server cannot fail over

because its only backup node is the primary for another Virtual SQL

Server providing an instance with the same name.

In the following simple example, Virtual SQL Server VSQL1 is providing

Instance1, with the primary on node1 and the backup on node2. Virtual

SQL Server VSQL2 is also providing an Instance1, with the primary on

node3 and the backup on node 2. The Virtual SQL Servers are sharing a

backup node for Instance 1, as it is unlikely that both Virtual SQL Servers

will fail over at the same time.

Node 2

Backup:

VSQL1, Instance1

VSQL2, Instance1

Node 1

Primary:

VSQL1, Instance1

Node 3

Primary:

VSQL2, Instance1