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

4 Update SQL Server instances
This chapter describes how to install Service Packs and Hotfixes on SQL Server instances.
In general, you can install any updates as needed. However, HP prequalifies Service Packs to ensure
compatibility with HP PolyServe Software. Check the compatibility matrix on www.hp.com for a list
of prequalified Service Packs.
http://h18006.www1.hp.com/products/storage/software/polyserve/support/compatibility.pdf
Update overview
The Multi-Node Update Wizard for SQL Server should be used for all updates of SQL instances that
have been virtualized with HP PolyServe Software. 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 Update Wizard can install SQL Server 2005/2008 Service Packs, SSAS 2005/2008
Service Packs, and 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 Update
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). An example of a UNC path is \\myNetworkShare\media\SQL2008.
Maintenance mode is required for update operations
Before installing a service pack or hotfix on a virtual SQL or SSAS instance, the Virtual SQL Server
(or Virtual SSAS) associated with the instance must be moved to maintenance mode.
NOTE:
Be sure to put any virtualized SQL or SSAS instances into maintenance mode before attempting to
patch the active node. You can patch any passive backup nodes without putting the Virtual SQL or
SSAS Server into maintenance mode.
For SQL updates, 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.
HP PolyServe Software for Microsoft SQL Server administration guide 49