3.6.0 Matrix Server Command Reference (5697-7083, December 2007)

Chapter 3: mx Commands 119

mx vsql – Virtual SQL Server commands

Use the following mx vsql commands to configure Virtual SQL Servers or to

display their status.

add—Add a new Virtual SQL Server

mx vsql add [--policy autofailback|nofailback] [--application

<application_name>] [--msdtc] <ip> <name> <<network_interface> ...>

The options are:

[--policy

autofailback|nofailback]

The failback action that the SQL Virtual Server will take following failover to

a backup node. autofailback will fail back when a higher-ranked node

provides equal or greater services than the backup node; nofailback fails back

only if a higher-ranked node provides greater services than the backup node.

autofailback is the default.

[--application <application_name>]

The application tag associated with this Virtual SQL Server. If you do not

specify an application, the IP address for the Virtual SQL Server will be used.

[--msdtc]

Microsoft Distributed Transaction Coordinator (MSDTC) is used to

coordinate transactions between different SQL instances running on different

nodes in the cluster. There is one MSDTC service on each machine.

Command Description

add Add a new Virtual SQL Server

delete Delete a Virtual SQL Server

disable Disable a Virtual SQL Server

dump Dump the Virtual SQL Server configuration to stdout

enable Enable a Virtual SQL Server

maintain Place a Virtual SQL Server in maintenance mode

move Rehost a Virtual SQL Server

operate Return a Virtual SQL Server to operation mode

status View status for a Virtual SQL Server

update Modify an existing Virtual SQL Server