BACKUP (Create Backups) › BACKUP CXX (Back Up Directory) › When to Use › 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. For more information about the SQL Object Consistency Analyzer, see the CA Datacom/DB SQL User Guide.

Note: You can use the SQL Object Consistency Analyzer to determine whether CA Datacom Datadictionary, Data Definition Directory, Schema Information Tables areas, and the Directory are synchronized and to determine the steps needed to correct any problems.