Data backup and recovery

ConSol CM is a Java EE application with a classic three-tier architecture. Therefore, in general all standard mechanisms for data backup and restore of a Java EE application server with a database connection apply. Some specifics about ConSol CM are explained here.

Your backup and recovery strategy needs to cover the following:

• ConSol CM database: Back up your database using standard mechanisms.

• DWH database: Large DWH databases should be backed up using standard mechanisms. Small DWH databases can be recreated from scratch by using the data transfer feature on the Administration page of the DWH menu of the Web Admin Suite.

  Performance hint

  Reporting is not possible while the data transfer runs. Depending on the size of the DWH, the initial transfer operation required to recreate the database can take several days or even weeks.

• ConSol CM configuration: Export a scenario containing all configuration data using the Staging export page of the Web Admin Suite and save it on a share which is included in the backup system. Only the system properties which have Included in staging export selected are included in the scenario. To back up all properties, you can either export a scenario including all system properties on the Custom export page of the Web Admin Suite or export the table cmas_configuration of the ConSol CM database.

• ConSol CM index: All ConSol CM indices are stored on the file system. You need to follow the instructions described in Backup and recovery of the index