How come on CommandCentral Storage 5.2 Release Update 4 Windows MS installation the Database Backup option does not backup the ASA database files as expected.

Problem
CommandCentral Storage  (CCS) 5.2 Release Update (RU) 4 contains a code change to alter the default directory for backing up the Sybase ASA database prior to upgrade for preservation of a known good copy of the database until the upgrade is completed. The change was to allow an Administrator to choose where to place the database in a file system of their choosing instead of the default location on the system drive.

Environment
 Windows Server Operating System

CommandCentral Storage (CCS) Management Server (MS) 5.2, RU1, RU2, RU3, RU4

Cause
 The code modification contains a defect that does not complete the backup automatically and manual intervention is required.

Solution
On CCS5.2RU4 Windows MS installation the Database Backup option does not backup the database files.

  Directory of C:\Program Files (x86)\VERITAS\CommandCentral Storage Data\Database

10/19/2012  02:53 PM        94,650,368 ccstor.db
10/19/2012  02:53 PM           196,608 ccstor.log
10/19/2012  02:53 PM         5,169,152 ccstordm.db
10/19/2012  02:35 PM             4,096 ccstordm.log

A manual backup is required, please take the backup of the database manually before upgrading to RU4 as below:

    Create a directory "dbsnapshot" on the disk where sufficient space is available
        md f:\dbsnapshot
    cd "C:\Program Files\VERITAS\CommandCentral Storage\Support\Tools"
    dbbackup.bat  <path to dbsnapshot dir>
        dbbackup.bat f:\dbsnapshot


After completion of backup, you will find ccstor.db and ccstordm.db backed up .

In some cases, ccstor.log and ccstordm.log may also be present.

Note: If present, the log files are required parts of the snapshot.

For further information and other files that can be manually backed up please see the associated articles below.

Veritas CommandCentral™ 5.2 RU4 Release Notes Article URL http://www.symantec.com/docs/DOC6048

The CommandCentral Storage upgrade installer does not prompt for a location to place the backup database copy.    Article URL http://www.symantec.com/docs/TECH190867

Backing up the CommandCentral database Article URL http://www.symantec.com/docs/HOWTO36798

Backing up and restoring Management Server configuration files Article URL http://www.symantec.com/docs/HOWTO20145

dbbackup — a script that backs up and restores the CommandCentral Storage database Article URL http://www.symantec.com/docs/HOWTO36785

 

 Install the upgrade without selecting to backup the database: