BACKUP (Create Backups) › BACKUP CXX (Back Up Directory) › Databases Accessed by SQL Statements

Databases Accessed by SQL Statements

If your site uses SQL, backing up the Directory without backing up the DATA-DICT and Data Definition Directory (DDD) databases can result in loss of synchronization which is critical for SQL operations. To retain synchronization when you back up the Directory, you must back up the DATA-DICT database and the DDD database.

Note: See the CA Datacom/DB SQL User Guide for information about the SQL Object Consistency Analyzer. You can use the SQL Object Consistency Analyzer to determine whether CA Datacom/DB, Data Definition Directory, Schema Information Tables areas, and the Directory are synchronized and to determine the steps needed to correct any problems.