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

Upgrade SQL Server Instances

This chapter describes how to install Service Packs and Hotfixes on SQL

Server instances.

Upgrade Overview

The Multi-Node Upgrade Wizard for SQL Server should be used for all

updates of SQL instances that have been virtualized with MxDB for SQL

Server. The wizard updates both the local profile and the +1 profile on the

active node. If the Wizard is not used for an update, version mismatches

can occur between the virtual and original registry and the data files on

the active node.

The Multi-Node Upgrade Wizard can install the following:

• SQL Server 2005 Service Packs

• SQL Server 2000 Service Packs

• Certain SQL Server hotfixes

Location of Service Packs and Hotfixes

The SQL Server product files must be in a location that can be reached by

the Multi-Node Upgrade Wizard for SQL Server. The files must be placed

in one of these locations:

• A PSFS filesystem on the SAN storage.

• A CIFS share referenced by UNC path (the share cannot be specified

by a mounted DOS drive letter).