3.4.3 MxDB for SQL Server Installation and Administration Guide

Chapter 3: Configuration and Operation 62

Click Run to start the rehost operation. The tasks are checked off as they

are performed. When all tasks are completed successfully, the PolyServe

Management Console will show the new primary node for the Virtual

SQL Server.

If a particular task fails, it is marked with an X on the progress report and

you are asked if you want to continue the operation. The progress report

provides two options that can be used if a task fails:

• Run. Click this button again to retry the failed task.

• Undo. Click this button to undo all tasks in the list and return the

Virtual SQL Server to its original state.

You can also cancel the operation at any time by clicking the Cancel

button. MxDB for SQL Server will undo each of the completed steps and

return the Virtual SQL Server to its original state.

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

command:

mx vsql move [--policy autofailback|nofailback]

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

([<networkinterface> ...])

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