3.4.3 MxDB for SQL Server Installation and Administration Guide

Chapter 3: Configuration and Operation 67

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

command:

mx vsqlinstance delete <vsql\instance>

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.

Stop the SQL Service

To stop the SQL service on a particular node, first move all Virtual SQL

Servers on the node into maintenance mode. You can then use your

normal procedure to stop the SQL service.

Database Backups

When you back up the master database directory, be sure to include the

following files:

•sql.original

•sql.preg

•vsql.db

MxDB for SQL Server requires these files for failover operations.