Backing Up Multiplex Databases

Follow these guidelines to back up multiplex databases.

Prerequisites
Read the rest of the backup topics for complete details before you perform a backup.
Task
  1. To back up the IQ store and catalog store on a multiplex database, connect to the coordinator using an account with the BACKUP DATABASE system privilege.
  2. Issue a BACKUP statement, which backs up:

    • The catalog store (SYSTEM dbspace file), typically named dbname.db

    • All dbspace files of the IQ store

  3. Make a copy of the params.cfg file for each server. BACKUP does not back it up.
  4. Save the lengths of the IQ temporary store and all dbspace files on the coordinator.
Parent topic: Back Up and Restore
Related concepts
Backup Requirements
Related reference
BACKUP Statement