4.1.0 HP PolyServe Software for Microsoft SQL Server administration guide (T5392-96074, October 2010)

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. HP PolyServe Software requires the files for failover operations.
• sql.original
• sql.preg
• vsql.db
Configure Virtual SQL Servers96