Loading...

Moving the Database Engine Back to the CommServe Computer

Applies to: Upgrades from V9 to V11

If your version 9 CommServe database and the Microsoft SQL Server are installed on different computers, you must move the CommServe database back to the CommServe computer before the upgrade.

In SnapProtect V11, configuring the CommServe software and the Microsoft SQL Server on separate computers is no longer supported.

Procedure

  1. Stop all services and disable all activities on the CommServe computer.

    To stop all services:

    1. Log on to the CommServe computer.
    2. Click Start and click All ProgramsSnapProtect > Process Manager.
    3. On the Services tab, stop all activities.

    To disable all activities:

    1. From the CommCell Browser, right-click the CommServe node and then click Properties.
    2. In the CommCell Properties dialog box, click the Activity Control tab and clear the Enable All Job Activity check box.
    3. Click OK.
  2. Move the CommServe database dump file from the Microsoft SQL Server computer to the CommServe computer.
  3. Restore the dump file on the Microsoft SQL Server of the CommServe computer.
  4. Update the SQL Server account settings.

    On the CommServe computer, use the following steps to update some registry values to point back to the CommServe computer:

    1. Open the Windows Registry Editor and go to the following directory:

      HKEY_LOCAL_MACHINE\SOFTWARE\CommVault Systems\Galaxy\Instance<xxx>\Database

    2. Update the values of the following registry keys:

      sCONNECTION set it to <CommServe computer>_commserv

      sDOMAIN set it to <CommServe computer>

      sINSTANCE set it to <CommServe computer>\NetApp

  5. Change the DSN settings.

    On the CommServe computer, modify the DSN settings for the CommServe database to point to the CommServe computer.

    1. On the Windows Control Panel window, click Administrative Tools > Data Sources (ODBC).
    2. On the System DSN tab, select <CommServe computer>_commserv and then click Configure.

      The Microsoft SQL Server DSB Configuration wizard opens.

    3. On the first page, edit the following values:
      • In the Name box, update the value to <CommServe computer>_commserv.
      • In the Server box, update the value to <CommServe computer>\NetApp.
    4. On the second page, do the following:
      • Select the With SQL Server authentication using a login ID and password entered by the user option.
      • Select the Connect to SQL Server to obtain default settings for the additional configuration options check box and enter the user credentials of the sa user.
    5. On the third and fourth page, do not make any changes.
    6. On the fifth page, click Test Data Source.

      The result should be TEST COMPLETED SUCCESSFULLY!.

    7. Click OK.
  6. Start all the services and enable all the activities on the CommServe computer.

    To start all services:

    1. Log on to the CommServe computer.
    2. Click Start and click All ProgramsNetApp, Inc. > Process Manager.
    3. On the Services tab, start all activities.

    To enable all activities:

    1. From the CommCell Browser, right-click the CommServe node and click Properties.
    2. In the CommCell Properties dialog box, click the Activity Control tab and click the Enable All Job Activity check box.
    3. Click OK.
  7. Enable disaster recovery (DR) backups.
    1. From the CommCell Browser, right-click the CommServe node and click View > Schedules.
    2. In the Schedules window, right-click the DR Backup Full schedule and click Enable.
  8. Disable automated scripts for installing updates.

    If you have automated scripts to install software updates, you can disable them because you can install updates from the CommCell Console. For more information, see Configuring Automatic Service Pack Installations.

What to Do Next

Continue with Plan the CommServe Upgrade. However, if you are ready to perform the upgrade, see Upgrading the CommServe Software.