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

In-place upgrade prerequisites
Before starting the upgrade, complete these steps:
• Back up all databases that will be upgraded.
• Prepare databases for the upgrade. Use Microsoft Upgrade Advisor or a similar tool. The Upgrade
Advisor analyzes the SQL Server 2005 instances and reports issues that may affect the upgrade.
It also provides tips for fixing or working around the issues.
• Stop PolyServe Instance Aliasing (Open services.msc and stop the service).
• Start the SQL Browser. If you are using Instance Aliasing, see “Configure Instance Aliasing set-
tings” on page 108 for information about stopping the PolyServe SQL Browser and starting the SQL
Browser.
• Ensure that the VSQL/VSSAS is running on its primary node and not on any backup node.
• Place the Virtual SQL/Virtual SSAS instances into maintenance mode. (Select the Virtual SQL
Server/Virtual SSAS on the PolyServe Management Console, right-click, and select Maintain.)
Restrictions
Following are some of the Microsoft restrictions affecting the upgrade.
• A cross-platform, in-place upgrade from a 32-bit instance of SQL Server 2005 (x86) to a 64-bit
instance of SQL Server 2008 (x64) is not supported.
• The in-place upgrade cannot be used if you want to upgrade only a single database.
• Upgrading in place is not recommended for certain SQL Server components such as some DTS
packages. Also, Notification Services cannot be upgraded in place.
• When the in-place upgrade process is running, avoid making any changes to the legacy SQL
Server 2005 system.
• All instance-specific components are upgraded; Microsoft does not support having different versions
of instance-specific components.
For a complete list of the Microsoft restrictions, refer to the SQL Server information on the Microsoft
developer network:
http://msdn.microsoft.com/en-us/sqlserver/default.aspx
Run the Multi-Node In-Place Upgrade Wizard
Before starting the wizard, be sure to review the prerequisites and restrictions described under “Prepare
for the upgrade” on page 37. Also be sure that the product files are in a location that can be accessed
by the wizard.
Start the In-Place Upgrade Wizard
To start the In-Place Upgrade Wizard, select Tools > In-Place Upgrade SQL on the PolyServe
Management Console. The Welcome Screen displays a warning listing information and prerequisites
for the upgrade. Verify that the prerequisites are met and then click OK.
Upgrade SQL Server/SSAS 2005 instances in place38