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

Chapter 5: Configuration and Operation 79

Virtual SQL Server Procedures

Modify the Configuration

To modify the configuration of a Virtual SQL Server, select it on the

Management Console window, right-click, and select Properties. You can

then change the configuration.

NOTE: If MSDTC was previously virtualized, be sure to check “Manage

msdtc” on the Update Virtual SQL Server dialog to continue the

virtualization on the new primary node. If this option is not

checked, MSDTC will not be virtualized.

The following restrictions apply:

• The primary network interface cannot be changed.

• Additional backup network interfaces can be added; however, the

nodes providing the network interfaces must have SQL instances with

the same names as the instances associated with the Virtual SQL

Server. An instance on the new node cannot currently be the primary

for a different Virtual SQL Server; however it can be a backup.

To change the configuration from the command line, use this command:

mx vsql update [--policy autofailback|nofailback]

[--application <application_name>] [--msdtc] <ip> <name>

([<networkinterface> ...])

Be sure to specify the --msdtc option if MSDTC should be virtualized. If

this option is omitted, MSDTC will not be virtualized.

Virtualize or Devirtualize MSDTC

You can change the virtualization status of MSDTC at any time. Use one

of these methods:

• Select the Virtual SQL Server on the PolyServe Management Console,

right-click, and select Properties. Then check or uncheck “Manage

MSDTC” as needed.

•Use the mx vsql update command and include or exclude the --msdtc

option as appropriate.