DBUpgrade

Scope

Release

Description

• When the regular upgrade process fails.
• When the CommServe software and database are installed on separate computers.
• To Upgrade a 32-bit CommServe installed on a Microsoft Windows x64 platform.

Usage

• To upgrade the software to QiNetix 8.0.0, the DBUpgrade utility must be run on a computer in which Microsoft SQL Server 2005 is installed.
• Verify and ensure that QiNetix Services are stopped before performing the upgrade.

Running the Utility

1. Copy the DBUpgrade folder from the Resource Pack to a local folder in your hard drive.

   NOTES

   Do not copy the files to the QiNetix install folders - create a separate folder.

   On cluster setup, copy the files to a shared drive.

2. Run DBUpgrade.exe from the local folder.
3. The Galaxy Database Upgrade dialog box displays the following Upgrade Types:
   • Production Upgrade - Use this option to upgrade the database after successfully performing a Test Upgrade of the database. The Production Upgrade process creates a backup of the CommServ database and then upgrades the database to the current version.
   • Test Upgrade - Use this option to test the database upgrade - if the test upgrade completes successfully run the Production Upgrade. The Test Upgrade process creates a backup of the CommServ database and then upgrades the database to the current version and then saves the database in a new location.

Running the Test Upgrade

1. Click the Test Upgrade option in Upgrade Type and click Next to continue.
2. Select the Host Name and in CommServ Host Name and click Next to continue. This is the host computer name, which will be the name of the computer in which the DBUpgrade utility is currently executed.
3. In the Database Information area, select the SQL Server Instance name, i.e., <host_name>\COMMVAULTQINETIX  in a non clustered environment or the name of the instance in which the CommServ database was installed in a clustered environment.

   The User Name and Password are automatically populated.

   Select CommServ from the Database list. (If necessary you can also select a backup copy of the CommServ database in the Test mode.)

   In the Enter the path to create a backup of COMMSERV Database box, enter a path (or use the Browse button) to specify a path for saving a backup copy of the database.

   NOTES

   On cluster setup, the database backup location should be to a shared drive.

   In the Enter the path to restore the COMMSERV Database box, enter a path (or use the Browse button) to specify a path for restoring the database before the upgrade.

   NOTES

   On cluster setup, the database restore location should be to a shared drive.

   Click Next to continue.

4. Verify the summary of selected option and then click Upgrade to continue.

   The utility will upgrade the database and save the new database (Commserv_Test_Upg_<Timestamp>) in the location specified in step 3.

   The utility reports the success/failure of the upgrade process. If necessary you can click the View Log button.

Running the Production Upgrade

1. Click the Production Upgrade option in Upgrade Type and click Next to continue.
2. Select the Host Name and in CommServ Host Name and click Next to continue. This is the host computer name, which will be the name of the computer in which the DBUpgrade utility is currently executed.
3. In the Database Information area, select the SQL Server Instance name, i.e., <host_name>\COMMVAULTQINETIX  in a non clustered environment or the name of the instance in which the CommServ database was installed in a clustered environment.

   The User Name and Password are automatically populated.

   Select CommServ from the Database list. (Only the CommServe database will be available in the Production mode)

   In the Enter the path to create a backup of COMMSERV Database box, enter a path (or use the Browse button) to specify a path for saving a backup copy of the database.

   NOTES

   On cluster setup, the database backup location should be to a shared drive.

   Click Next to continue.

4. Verify the summary of selected option and then click Upgrade to continue.

   The utility will upgrade the database and save the new database (Commserv_Test_Upg_<Timestamp>) in the location specified in step 3.

   The utility reports the success/failure of the upgrade process. If necessary you can click the View Log button 

Viewing Log Files

The log files are located in the directory from which the DBUpgrade utility is launched.

• Use the [UpgradeDBObject.log] to check database whether the database upgrade completed successfully.
• Use the [DBUpgrade.log] to view the warnings etc. that were logged during the upgrade.
• Use the [checkFor59PriorClients.log] to obtain a list of client(s) which are in prior release versions.

History

Disclaimer of Warranties

CommVault provides software tools and utilities on an "as is" basis, as a courtesy and convenience to its users, and they may be changed from time to time without notice. These tools and utilities are provided without express, implied, or statutory warranties of any kind. You assume full risk and responsibility for the selection, possession, performance and proper installation and use of the software tools and utilities, and for verifying the results obtained there from. Your use of CommVault software tools and utilities indicates your unconditional acceptance of the above disclaimer.