SRM Server - Database Upgrade

Table of Contents

Overview

Prerequisites

Upgrade Process

Overview

This procedure is used to upgrade the SRM Server databases on a separate computer, to ensure that the Production Server does not get disrupted during the process of upgrade.

Note that before upgrading the SRM Server database, you must perform CommServe database upgrade. See CommServe - Database Upgrade for step-by-step procedure.

The following section describe the process of upgrading a database of the SRM Server.

Prerequisites

Upgrade Process

1. On the production computer were the SRM server resides, perform a Disaster Recovery Backup of SRM Server database.

Make sure that the associated disaster recovery folder (SET_XXX folder) is saved and available in a safe location.

 See Starting a Disaster Recovery Backup for step-by-step instructions.
2. On the standby computer, install the CommServe, SRM Server software and the Database Upgrade tool.

Make sure that all the updates are installed on the standby CommServe.

 See Install the SRM Server Software for more information on installing CommServe and SRM Server software.

See Install the Database Upgrade tool for more information.
3. On the standby computer, restore the disaster recovery backup of SRM  server database using the Disaster Recovery Tool. See Restore a Disaster Recovery Backup for step-by-step instructions on restoring the database.
4. Upgrade the databases, using the Database upgrade tool.

NOTES:

  • If the database upgrade succeeds, skip to Next step.
  • If the upgrade does not succeed contact your Software Provided for assistance.
 Run the following command to upgrade for:

SRM Server database:

DatabaseUpgrade -PhaseName "All" -instance "Instancexxx" -productName "SRM" -DBUpgradeDir <dir db upgrade> -log <log folder name> -DBBackupDir <dr backup dir>

where:

  • Instancexxx - specify the Instance number to which the software is installed.
  • log folder name - specify the path to create a log file.
  • dr backup dir - specify the path to store a database backup before upgrading.
5. On the standby computer, use the SQL Server Management Studio, to backup the upgraded SRM database and create a .dmp file. See the SQL Server Management Studio help for information on backing up a database.
6. On the production Server, uninstall the old version and re-install the latest version of the SRM Server software. See Uninstalling Components for more information on uninstalling CommServe software.

See Install the SRM Server Software for more information on installing CommServe software.
7. On the production server, restore the SRM database using the Disaster Recovery tool. See Restore a Disaster Recovery Backup for step-by-step instructions.