4.0.0 HP PolyServe Software for Microsoft SQL Server Administration Guide (T5392-96056, March 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 SQL Mail and SQL Agent Mail
The setup for SQL Mail and/or SQL Agent Mail is the same with or without HP PolyServe Software
installed. It is recommended that you use domain authentication, and that the same domain user be
configured for each of the following:
• SQL Server startup account
• SQL Server Agent startup account
• MAPI profile
See the following Microsoft Knowledge Base articles for more information:
http://support.microsoft.com/kb/263556
http://support.microsoft.com/kb/311231
Configure Virtual SQL Servers74