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 ............................ 37
Prepare for the upgrade ............................................................................................................ 37
Supported upgrades ........................................................................................................... 37
Prerequisites ...................................................................................................................... 37
SQL Server 2008 prerequisites ...................................................................................... 37
In-place upgrade prerequisites ....................................................................................... 38
Restrictions ........................................................................................................................ 38
Run the Multi-Node In-Place Upgrade Wizard .............................................................................. 38
Start the In-Place Upgrade Wizard ....................................................................................... 38
“Select the Microsoft product to upgrade” dialog .................................................................... 39
“Installation Credentials” dialog ........................................................................................... 41
“Select the Instances to Upgrade” dialog ............................................................................... 41
“Select Template File” dialog ............................................................................................... 43
Move Virtual SQL Servers/Virtual SSAS to operate mode ......................................................... 45
Add, edit, or delete products ...................................................................................................... 46
4 Update SQL Server instances ............................................................. 49
Update overview ...................................................................................................................... 49
Location of service packs and hotfixes ................................................................................... 49
Maintenance mode is required for update operations ............................................................. 49
Update considerations for SQL Server 2008 .......................................................................... 50
Extract zip files ............................................................................................................ 50
Service pack and hotfix names ...................................................................................... 50
Use of a hidden administrative share .............................................................................. 50
Update considerations for SQL Server 2005 .......................................................................... 50
Instance-Aware components .......................................................................................... 50
Extract zip files ............................................................................................................ 50
SQL Server 2005 SP2 required for Full Text Search .......................................................... 50
SQL Server 2005 hotfix 2153 ....................................................................................... 51
Service pack and hotfix names ...................................................................................... 51
Use of a hidden administrative share .............................................................................. 51
Installation log files ............................................................................................................. 51
Run the Multi-Node Update Wizard for SQL Server ....................................................................... 51
5 Configure Virtual SQL Servers ............................................................ 57
Configure Virtual SQL Servers .................................................................................................... 57
DNS requirement for Virtual SQL Servers ............................................................................... 57
Create a Virtual SQL Server ................................................................................................. 57
Progress reports ........................................................................................................................ 60
Add a Virtual SQL instance ........................................................................................................ 60
View the Virtual SQL instances ............................................................................................. 62
Advanced options for monitors ................................................................................................... 63
Policy ................................................................................................................................ 63
Scripts .............................................................................................................................. 64
Use custom scripts to modify Start/Stop activities ............................................................. 65
Event severity .............................................................................................................. 66
Script ordering ............................................................................................................ 66
Configure SQL clients ................................................................................................................ 66
Rehost a Virtual SQL Server ........................................................................................................ 68
Performance monitoring with perfmon .......................................................................................... 69
Other SQL Server procedures ..................................................................................................... 70
Maintenance mode ............................................................................................................ 70
Create a notifier for the Registry Replicator ............................................................................ 70
4