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

• Use the mx vsql update command and include or exclude the --msdtc option
as appropriate.
HP PolyServe Software can virtualize MSDTC only when the Default Coordinator for
MSDTC is set to Use local coordinator on the nodes configured for the Virtual SQL
Server. If a Remote Host is specified as the Default Coordinator, HP PolyServe
Software cannot virtualize MSDTC.
Enable/disable a Virtual SQL Server
A Virtual SQL Server may be left in a disabled state after it is moved via a “drag
and drop” operation. Use the Enable feature to re-enable the Virtual SQL Server. To
do this, select the Virtual SQL Server on the PolyServe Management Console,
right-click, and select Enable on All Servers.
You can also disable a Virtual SQL Server if necessary. Select the Virtual SQL Server
on the PolyServe Management Console, right-click, and select Disable on All Servers.
To enable or disable a Virtual SQL Server from the command line, use these
commands:
mx vsql enable <vsql>
mx vsql disable <vsql>
Delete a Virtual SQL Server
To remove a Virtual SQL Server, select it on the PolyServe Management Console,
right-click, and select Delete.
To delete a Virtual SQL Server from the command line, use this command:
mx vsql delete [--force yes|no] <vsql>
The --force yes option will delete a Virtual SQL Server on a node that is down.
View status for a Virtual SQL Server
The PolyServe Management Console shows the status of all Virtual SQL Servers
configured in the matrix. To view status from the command line, use this command:
mx vsql status [--up|--down] [--operational|--maintenance]
[--primary|--backup] [--active|--inactive] [--showApplication] <vsql>
HP PolyServe Software for Microsoft SQL Server 4.1 administration guide 93