Upgrading Microsoft SQL Server Editions

Updated

You can upgrade old Microsoft SQL Server editions to Microsoft SQL Server 2019 Standard Edition on the CommServe computer. The following procedure ensures that older components such as .NET Framework are removed. You should consider performing a hardware refresh or a VM refresh at same time you upgrade to Microsoft SQL Server 2019 Standard Edition.

Note:

  • Beginning Feature Release 11.24, Commvault uses Microsoft SQL Server 2019 Standard Edition on Windows OS 2016 or higher.

  • Microsoft SQL Server 2019 is not compatible with Windows OS 2012. If you are running Windows OS 2012 or Windows OS 2012 R2, then Microsoft SQL Server 2016 will be installed as part of a fresh CommServe server installation.

Before You Begin

  • Write down all Commvault-related components that are currently installed on the CommServe computer (for instance, Workflow Engine and Web Server). You will need to re-install these components in Step 6 of the Procedure, below. To view the components that are currently installed, do the following:

    • From the CommCell Browser, right-click the CommServe and then click Properties.

    • In the CommCell Properties dialog box, click the Version tab. The packages are listed in the Update status area.

  • Verify that the disaster recovery backup files are saved in a location different than the Commvault software location.

    As part of the SQL Server upgrade process, you will uninstall the Commvault software, and all Commvault files will be deleted. If you save the DR backup in the same location, the CommServe database dump file (the only remaining copy of your CommServe database) will also be deleted.

    For information about setting the location of DR backup files, see either of the following:

  • For Commserve LiveSync environments, review the following information:

    • Perform this upgrade procedure on both the production CommServe host and the standby CommServe host.

    • Both the production CommServe host and the standby CommServe host must be upgraded to the same version of SQL and the same version of Commvault software.

    • The name for the new standby CommServe host must remain the same as the previous standby CommServe host during the installation. Do not specify a new client name for the standby host. Otherwise, LiveSync operations fail and you will have to reconfigure the installation.

Procedure

Note: Instead of performing Step 1 and Step 3, below, you may run the SQL Edition Upgrade workflow instead. This workflow disables CommCell activities, creates a disaster recovery backup, and sends an email with consolidated information. For more information, see Running SQL Edition Upgrade Workflow.

  1. Disable CommCell activities as follows:

    • From the CommCell browser, do the following:

      1. Right-click the CommServe node, and then click Properties.

        The CommCell Properties dialog box appears, as follows:

      2. On the Activity Control tab, clear all options except Enable All Job Activity, and then click OK.

        This ensures that no new jobs are performed, except for disaster recovery operations, VM provisioning jobs, and workflow jobs.

      3. From the Job Controller, kill all jobs that are in progress, or wait for the jobs to finish.

    • From the Command Center, do the following:

      1. From the navigation pane, go to Manage > CommCell.

        The CommCell management screen appears, showing the Activity Control section, as follows:

      2. Under Activity Control, clear all options except All Job Activity.

        This ensures that no new jobs are performed, except for disaster recovery operations, VM provisioning jobs, and workflow jobs.

  2. For CommServe LiveSync environments, do the following:

  3. Perform a disaster recovery (DR) backup as follows:

    IMPORTANT: Before you perform a DR backup, write down the location of the DR backup folder. For more information, see "Before You Begin", above.

    • From the CommCell Browser, do the following:

      1. Right-click the CommServe node, and then click All Tasks > Disaster Recovery Backup.

      2. In the Disaster Recovery Options dialog box, click OK.

    • From the Command Center, do the following:

      1. Go to Manage > System.

        The System page appears.

      2. Click the Maintenance tile.

        The Maintenance page appears.

      3. Click the DR backup (Daily) tile.

      4. Click the Run job icon .

  4. Uninstall the CommServe software. For more information, see Uninstalling the CommServe Software.

    Note: You can ignore the requirement to uninstall MediaAgent and client computers mentioned in the uninstallation procedure.

  5. Uninstall the currently installed Microsoft SQL Server software. For instructions, refer to the Microsoft documentation.

  6. Install the latest Long-Term Support (LTS) Commvault platform release or the latest Commvault platform release on the same hardware or on new hardware (for more information, see Installing Commvault Locally Using the Download Manager). During the installation procedure, enter the location of the CommServe database DR backup file (also called the dump file). This DR backup file is automatically upgraded if necessary. To submit the DR backup file, perform the following steps during the installation:

    1. On the Database Install Option page (see below), select Use Existing Database, select CommServe.

      If you had other Commvault-related server packages installed on the CommServe computer (for example, Workflow Engine and Web Server), select the options associated with them.

    2. Under Database Dump Location, specify the location of the CommServe database DR backup file (and of any other database that you selected), and then click Next.

      The dump files are located with your DR backup files. For example, the default name for the CommServe dump file is commserv.dmp.

    3. On the Database Restore Options page (see below), select Recovery/Production in order to restore the environment.

  7. For CommServe LiveSync environments, reinstall Instance 1 and instance 2 on the Standby CommServe Host. Install the Commvault software packages on the standby CommServe host. For more information on installing the packages on the production CommServe host, see Installing the Standby CommServe Host.

  8. Enable CommCell activities as follows:

    • From the CommCell Browser, do the following:

      1. Right-click the CommServe node and then click Properties.

        The CommCell Properties dialog box appears.

      2. On the Activity Control tab, enable all the activities that you cleared when the CommServe database was on the old hardware, and then click OK.

    • From the Command Center, do the following:

      1. Go to Manage > CommCell.

        The CommCell management screen appears, showing the Activity Control section.

      2. Under Activity Control, enable all activities.

  9. For CommServe LiveSync environments, repeat Steps 1 through 8, above, on the standby CommServe node.

  10. For CommServe LiveSync environments, do the following: