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

Chapter 5: Configuration and Operation 83

To delete a Virtual SQL Instance from the command line, use this

command:

mx vsqlinstance delete <vsql\instance>

Revirtualize a Virtual SQL Instance

Occasionally you may need to delete a Virtual SQL Instance temporarily

and restore the instance to its original state. When you recreate the

Virtual SQL Instance with the Add SQL Instance dialog, a popup

message states that the data files for this instance already exist. To reuse

these data files with the new Virtual SQL Instance, click Revirtualize.

If you do not want to use the existing datafiles, click Virtualize.

NOTE: The selected virtual path root (or vpath) directory must match the

name of the instance being revirtualized. If the names do not

match, the instance will not start.

View Status for a Virtual SQL Instance

The PolyServe Management Console shows the status of all Virtual SQL

Instances configured in the matrix. To view status from the command

line, use this command:

mx vsqlinstance status [arguments] <vsql\instance>

The arguments are:

[--up|--down]

[--primary|--backup]

[--enabled|--disabled]

[--active|--inactive]

[--showApplication]

With no arguments, the command shows status for all SQL monitors.

SQL Agent

If the SQL agent fails, a message will appear in the Alert area of the

PolyServe Management Console. Failover will not occur.