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

Chapter 3: mx Commands 122

add—Add a Virtual SQL Instance

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

<vsql\instancename>

The arguments are:

--vpath <path>

The full path that will be used for the data files and directories for this virtual

SQL Server instance. This location will store the SQL Data Root that was

created when the SQL Server instance was installed.

--port <TCP_port>

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.

[--frequency <seconds>]

The interval of time, in seconds, at which the monitor runs the probe. The

default is 10 seconds.

[--restarts <number of restarts>]

The number of attempts that should be made to restart the SQL service

instead of immediately failing over the Virtual SQL Server. If you do not

specify a number for this component, the Virtual SQL Server will fail over

immediately to a backup node.

[--probeSeverity nofailover|autorecover|noautorecover]

This setting determines what happens when the SQL monitor probe fails.

With nofailover, when the monitor probe fails, the Virtual SQL Server does

not fail over to a backup node. With autorecover, the Virtual SQL Server fails

over when the monitor probe fails, and failback occurs according to the

Virtual SQL Server policy (either

AUTOFAILBACK or NOFAILBACK). With

noautorecover, failover occurs to a backup node and the monitor is disabled

on the original node.

[--ordering SERIAL|PARALLEL]

Whether Matrix Server enforces a strict ordering sequence when it runs Start

or Stop scripts. The default is serial, the strict ordering sequence.