3.4.0 Matrix Server Command Reference

Chapter 2: mx Commands 83

Rehost a Virtual SQL Server:

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

<application_name>] <ip> <name> ([<network_interface> ...])

The options are the same as vsql add.

Delete a Virtual SQL Server:

mx vsql delete <vsql>

Place a Virtual SQL Server in maintenance mode:

mx vsql maintain <vsql>

Return a Virtual SQL Server from maintenance mode to operation mode:

mx vsql operate <vsql>

View status for a Virtual SQL Server:

mx vsql status [--up|--down] [--operational|--maintenance]

[--primary|--backup] [--active|--inactive] [--showApplication]

<vsql>

Upgrade a Virtual SQL Server (obsolete):

mx vsql upgrade

This command was used in a previous release to upgrade MxDB for SQL

Server. The command is now obsolete and should not be used.

mx vsqlinstance – Virtual SQL Instance commands

Use the following commands to configure Virtual SQL Instances or to display

their status.

Add a Virtual SQL Instance:

mx vsqlinstance add --port <TCP_port> [arguments]

<vsql\instancename>

The arguments are:

--port <TCP_port>

Enter the port number for TCP/IP Sockets that the SQL Server instance

should listen on. Specifying a port is required.

[--timeout <seconds>]

The maximum amount of time that will be waited for the probe to complete.

The default is five seconds.