CommServe - Database Upgrade

Note that the DBUpgrade tool from resource pack in previous release is now renamed as Database Upgrade tool.

The following section describe the process of upgrading a database of the CommServe.

Perform the following steps to start a Disaster Recovery Backup:

1. From the CommCell Browser, right-click the CommServe, point to All Tasks, and then click Disaster Recovery Backup.
2. By default, the backup type is selected as Full.
3. Click the Client Selection tab to backup up the log files from clients with your CommCell.
4. Select the client(s) from the available list of clients.
5. Click the Job Initiation tab.
6. Click Immediate.
7. Click OK to run immediately.

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

See Install the Database Upgrade tool for step-by-step instructions.

Perform the following steps to restore a disaster recovery backup:

1. From the Windows Explorer, navigate to the <software installation path>\base folder.
2. Double-click CommserveDisasterRecoveryGUI.exe. This will launch the CommServe Disaster Recovery Tool.
3. Select the Restore DB check box.
4. In the Destination SQL Server Info, select Log in as: check box and provide the SQL Server user account credentials.
5. Select one of the restore options:
   • Click Restore All Databases From Folder to restore multiple databases from the specified folder containing the dump files.
   • Click Restore Single Database to restore a single dump file containing the database.
6. In the Restore file box, type or browse the name of the Disaster Recovery Backup file or folder where the dump files are located.
7. In Restore Path, click the Browse [...] button to change the target location of the files from the Restore DR DB file as: dialog box.

   To change the target perform the following:

   • In the Physical File Name column, click a row, type the new location and then click Find and Replace.
   • You will be prompted Do you want to replace all physical file locations to c for the restore, click Yes.
   • Click OK.
   • Click Yes to overwrite the existing Database.
8. In the Mail Server box, specify a valid mail server name to be used for e-mail messages.
9. In the Port box, specify the port number. The default Mail Server port number is 25.
10. In the Sender box, specify a valid e-mail address that displayed in the mail generated from the software.
11. In the Recipients box, specify a valid e-mail address of the recipient that will receive an e-mail message indicating that the restore operation has completed.
12. Click OK.

Click Next.

Click Next.

Click Next.

• In the Path to backup Database, click Browse [...] button to select the directory for database backup.
• In the DBUpgrade Log Location, click Browse [...] button to select the directory for logs.
• Click Next.

Click Close.

• Click the Start button on the Windows task bar and then click All Programs.
• Navigate to bull | Calypso and click Service Control Manager.
• Select All Services in Services.
• Click Start to start all services.

Perform the following steps to back up the upgraded database to a full database backup:

1. Open Microsoft SQL Server Management Studio.
2. Navigate to Server Instance | Database | CommServ.
3. Right-click the CommServ database, select Tasks and then click Backup. The Back Up Database dialog box appears.
4. In the Database, verify the database name.
5. In the Backup type, select Full.
6. In the Backup Component, select Database option.
7. Accept the default backup set name in the Name, or you can enter a different name for the backup set.
8. Specify when the Backup set will expire. By default After is selected with value 0.
9. In the Destination area select Disk option. To select the path, click Add. The selected path will be displayed in the Backup to list.

   To remove backup destination, select the destination path and click Remove.

10. Click OK.

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

Perform the following steps to restore a disaster recovery backup:

1. From the Windows Explorer, navigate to the <software installation path>\base folder.
2. Double-click CommserveDisasterRecoveryGUI.exe. This will launch the CommServe Disaster Recovery Tool.
3. Select the Restore DB check box.
4. In the Destination SQL Server Info, select Log in as: check box and provide the SQL Server user account credentials.
5. Select one of the restore options:
   • Click Restore All Databases From Folder to restore multiple databases from the specified folder containing the dump files.
   • Click Restore Single Database to restore a single dump file containing the database.
6. In the Restore file box, type or browse the name of the Disaster Recovery Backup file or folder where the dump files are located.
7. In Restore Path, click the Browse [...] button to change the target location of the files from the Restore DR DB file as: dialog box. To change the restore path perform the following:
   • In the Physical File Name column, click a row, type the new location and then click Find and Replace.
   • You will be prompted Do you want to replace all physical file locations to c for the restore, click Yes.
   • Click OK.
   • Click Yes to overwrite the existing Database.
8. In the Mail Server box, specify a valid mail server name to be used for e-mail messages.
9. In the Port box, specify the port number. The default Mail Server port number is 25.
10. In the Sender box, specify a valid e-mail address that displayed in the mail generated from the software.
11. In the Recipients box, specify a valid e-mail address of the recipient that will receive an e-mail message indicating that the restore operation has completed.
12. Click Name/License Change tab.
13. Select CommServe Name Change check box.
14. Select Activate License check box.

    Click Browse [...] button to specify the location of the license XML file.

15. Click OK.

Click Close.

• Click the Start button on the Windows task bar and then click All Programs.
• Navigate to bull | Calypso and click Service Control Manager.
• Select All Services in Services.
• Click Start to start all services.