4.1.0 HP PolyServe Software for Microsoft SQL Server administration guide (T5392-96074, October 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
HP PolyServe Software for Microsoft SQL Server 4.1 administration guide 45