Veritas InfoScale 7.1 Installation and Upgrade Guide - Windows
- Preinstallation and planning
- Installing the Veritas InfoScale products
- Upgrading to InfoScale products
- Performing the post upgrade tasks
- Administering the InfoScale product installation
- Uninstalling the InfoScale products
- Performing application upgrades in an InfoScale environment
- Upgrading Microsoft SQL Server
- Upgrading SQL Server 2008 to SQL Server 2008 R2
- Upgrading to later versions of SQL Server
- Upgrading SQL Server 2008 to SQL Server 2008 R2
- Upgrading Oracle
- Upgrading application service packs in an InfoScale environment
- Upgrading Microsoft SQL Server
- Appendix A. Services and ports
- Appendix B. Migrating from a third-party multi-pathing solution to DMP
Preupgrade tasks for upgrading SQL Server 2008 to SQL Server 2008 R2 in a disaster recovery environment
Before you proceed to upgrade the cluster nodes in a disaster recovery (DR) configuration, perform the following tasks on the secondary site for the SQL Server instances that you want to upgrade:
Freeze the service group using the VCS Cluster Manager (Java Console).
Obtain the drive letter on which the system database and the analysis service reside using the following command:
hadiscover -discover SQLServer2008 StartUpParams:InstanceName
The following is a sample output:
<Discovery> <Attr_Name> StartUpParams:INSTANCE2K8 </Attr_Name> <Discover_value> <Scalar_value> SQLDataPath: E:\Program Files\Microsoft SQL Server\ MSSQL10.INSTANCE2K8\MSSQL\DATA\ </Scalar_value> </Discover_value> <Discover_value> <Scalar_value> SQLErrLogPath: E:\Program Files\Microsoft SQL Server\ MSSQL10.INSTANCE2K8\MSSQL\LOG\ERRORLOG </Scalar_value> </Discover_value> <Discover_value> <Scalar_value> OLAPDataPath: E:\Program Files\Microsoft SQL Server\ MSAS10.INSTANCE2K8\OLAP\Data </Scalar_value> </Discover_value> </Discovery>
Attach a temporary disk and create a volume with the drive letter same as that for the instance on which the system database resides.
Note:
If you are upgrading more than one SQL Server instance that have the system database path and the OLAP data path on separate volumes, you must complete the upgrade of each instance on both the sites and then proceed to upgrade the next instance.
Review the
SQLDataPath
,SQLErrLogPath
and theOLAPDataPath
directories and create the same directories on the temporary disk.Note:
In case the directory path exists on different volumes, create the similar volumes first and then create the required directory paths.
Copy the following files from the primary site to the data path that you created on the secondary site:
master.mdf
mastlog.ldf
model.mdf
modellog.ldf
MSDBData.mdf
MSDBLog.ldf
tempdb.mdf
templog.ldf