3.4.3 MxDB for SQL Server Installation and Administration Guide

Chapter 3: Configuration and Operation 63

maintenance on the backup instance first and then reenable the

SQL service monitor for that instance. The backup instance will

then be available for the other primary instance.

To move a Virtual SQL Server to maintenance mode, select the Virtual

SQL Server on the PolyServe Management Console, right-click, and select

Maintain.

NOTE: Before placing the Virtual SQL Server into maintenance mode, be

sure that it is running on the primary node. This step ensures that

the virtual registry used by MxDB for SQL Server will be updated

properly.

When you have completed the maintenance activities, you can return the

Virtual SQL Server to operation mode. Select the Virtual SQL Server on

the PolyServe Management Console, right-click, and select Operate.

To place a Virtual SQL Server in maintenance mode from the command

line, use this command:

mx vsql maintain <vsql>

To return the Virtual SQL Server to operation mode, use this command:

mx vsql operate <vsql>

Change the Network Configuration (SQL Server 2005

Only)

The SQL Server 2005 instance installation captures and stores the current

IP network configuration of the node on which it is installed. If you later

need to change the network configuration (for example, to remove a NIC

or change its IP), it is necessary to devirtualize the Virtual SQL Servers

configured on the affected node, make the needed changes, and then

revirtualize.

To devirtualize a Virtual SQL Server, you will need to delete it from the

matrix configuration. Select the Virtual SQL Server on the PolyServe

Management Console, right-click, and select Delete.

After making your network changes, you can recreate the Virtual SQL

Server.