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

Chapter 4: Upgrade SQL Server Instances 35

Maintenance Mode Is Required for Upgrade

Operations

Before installing a service pack or hotfix on a virtual SQL instance, the

Virtual SQL Server associated with the instance must be moved to

maintenance mode.

If another Virtual SQL Server (with different instances) is active on the

node and is enabled for MSDTC, you will also need to move that Virtual

SQL Server to maintenance mode before you install the service pack or

hotfix on the instance that you are attempting to patch. If the

MSDTC-enabled Virtual SQL Server is not in maintenance mode, the

service pack installation will fail.

Upgrade Considerations for SQL Server 2005

Instance-Aware Components

When you perform an unattended installation of SQL Server 2005 SP1 or

a SQL Server 2005 hotfix, only instance-aware components (that is,

components related to the instance) will be installed. Non-instance-aware

components such as SSIS (DTS), Notification Services, and SQL Tools are

not updated. This is by Microsoft design.

To update the non-instance-aware components, you will need to install

SP1 or the hotfix manually and select those components (they are selected

by default). This needs to be done only once. You can then perform

unattended installations of the service pack or hotfix on your other SQL

Server 2005 instances.

The non-instance-aware components are installed automatically with

SQL Server 2005 SP2.

Extract Zip Files

Some hotfixes are provided in zip files. Be sure to extract the contacts of

the file and review the

README before starting the installation.

SQL Server 2005 Hotfix 2153

Hotfix 2153 for SQL Server 2005 SP1 can be installed via the upgrade

wizard; however, the SSIS/NS/Tools components will not be updated. If