4.0.0 HP PolyServe Software for Microsoft SQL Server Administration Guide (T5392-96056, March 2010)

3 Upgrade SQL Server/SSAS 2005
instances in place
This chapter describes how to upgrade SQL Server/SSAS 2005 instances to SQL Server/SSAS 2008
instances. The installation is called “in place” because the target SQL Server/SSAS 2005 instance is
replaced with a SQL Server/SSAS 2008 instance. The old SQL Server/SSAS 2005 data files are
automatically converted to the new format. All shared components and instance-specific components
are also upgraded.
Both virtualized and non-virtualized instances can be upgraded. For virtualized instances, you will
need to first place the instance into maintenance mode and then upgrade the instance. After the
upgrade, return the instance to operate mode. The monitor/probe will then monitor the upgraded
service.
The upgrade is performed with the Multi-Node In-Place Upgrade Wizard
Prepare for the upgrade
Supported upgrades
The following instances can be upgraded:
• MS SQL 2005 x86 SP1 Standard/Enterprise
• MS SQL 2005 x64 SP1 Standard/Enterprise
• MS SQL 2005 x86 SP2 Standard/Enterprise
• MS SQL 2005 x64 SP2 Standard/Enterprise
• MS SQL 2005 x86 SP3 Standard/Enterprise
• MS SQL 2005 x64 SP3 Standard/Enterprise
• MS SQL 2005 x86 Standard/Enterprise
• MS SQL 2005 x64 Standard/Enterprise
Prerequisites
SQL Server 2008 prerequisites
SQL Server 2008 requires that the following be installed:
• Windows Installer 4.5
• NET Framework 3.5 SP1
• SQL Server Native Client
• SQL Server Setup Support Files
• Powershell 1.0
HP PolyServe Software for Microsoft SQL Server administration guide 37