3.4.3 MxDB for SQL Server Installation and Administration Guide

Chapter 3: Configuration and Operation 64

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.

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> ...])

Delete a Virtual SQL Server

To remove a Virtual SQL Server, select it on the PolyServe Management

Console, right-click, and select Delete.

NOTE: If the Virtual SQL Server had been rehosted, the SQL instances

associated with the Virtual SQL Server will be unusable after the

Virtual SQL Server is deleted. This situation occurs because the

rehost operation changes the SQL registry settings. If you want to

continue to use the SQL instances, you will need to reinstall them.

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

command:

mx vsql delete <vsql>