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

Chapter 5: Configuration and Operation 77

Other Procedures

Maintenance Mode

When you need to apply a service pack or perform other SQL

maintenance, you can move a Virtual SQL Server to maintenance mode.

This mode disconnects all clients accessing the SQL instances associated

with the Virtual SQL Server. All of these SQL instances are shut down on

the primary node and all backup nodes and the associated SQL service

monitors are disabled.

NOTE: If an instance on a backup node is also being used as a backup for

a primary instance associated with a different Virtual SQL Server,

that instance will no longer have a backup. To minimize the time

without a backup, we recommend that you perform the

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>