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

Chapter 8: Upgrade Production SQL Servers 122

2. If a node is a backup member of multiple Virtual SQL Servers, the

Virtual SQL Instance on that node will be disabled. Enable the Virtual

SQL Instance by selecting the monitor on the PolyServe Management

Console, right-click, and then select Enable.

3. Upgrade the SQL instance on the backup node.

4. Repeat steps 2 and 3 for each backup Virtual SQL Instance.

5. Upgrade the instance on the primary node.

6. Return the Virtual SQL Server to operational mode. Select the Virtual

SQL Server associated with the instance on the PolyServe

Management Console, right-click, and select Operate.

Multiple Instance Upgrades

You may want to perform a multiple-instance upgrade on consolidated

servers that hold many instances. These servers typically use one of the

configurations described earlier and the same general procedures can be

used. However, you should be aware of the following:

• A manual upgrade will probably necessitate a reboot, which will

affect all of the instances on the server. To avoid this, we recommend

that you use an unattended install, which does not require a reboot.

• Because the instances have a shared location, during the upgrade

there can be more than one version of SQL Server on the machine.

Other Information

The following manual provides additional information about upgrading

SQL Server:

Microsoft SQL Server™ 2000 High Availability

Alan Hirt with Cathan Cook, Kimberly L. Tripp, and Frank McBath

ISBN 0-7356-1920-4