Database Backup

Like the SpectroSERVER database, the DDM database requires regular backups to enable full recovery in the event of a hardware or operating system failure. Ideally, both of these databases are backed up daily to ensure the availability of current data and to keep the databases synchronized.
casp1032
Like the SpectroSERVER database, the DDM database requires regular backups to enable full recovery in the event of a hardware or operating system failure. Ideally, both of these databases are backed up daily to ensure the availability of current data and to keep the databases synchronized.
However, the DDM database is typically much larger than the SpectroSERVER database and thus requires more time for backups. Also, the Archive Manager must be shut down during the backup. As a result, a considerable backlog of historical data must often be processed when it is restarted. Backlog processing can adversely affect SpectroSERVER performance. For these reasons, we typically recommend backing up the DDM database weekly and backing up the SpectroSERVER database more frequently, preferably daily.
The DDM and SpectroSERVER databases can fall out of synchronization when you restore one without restoring the other. For example, you back up both databases on Sunday. You create a model on Monday, then experience a system crash and restore your SS database with the Sunday save file. The restored SS database no longer includes the model that you created, but historical records for that model are in the DDM database. Moreover, if you recreate the model, you cannot then reconcile the DDM records from the original model with the new records that were generated for the recreated model. Avoid this kind of conflict by always restoring the DDM database whenever you restore the SpectroSERVER database.
You can perform a DDM database backup at any time using the ddm_save or ddm_backup tools. However, you can also have the DDM database backed up automatically using the Online Backup feature. Online Backup uses the post_olb_script. Because it is critical to keep the SpectroSERVER and DDM databases synchronized, this script is the preferred method for DDM backups.
The tools that are described in this section (post_olb_script, ddm_backup, and ddm_save) are the only supported methods of backing up your DDM database. Use of third-party backup software can result in database corruption.