Backing Up the IQ Store and Catalog Store

This procedure summarizes backup steps.

Prerequisites
Read the rest of the backup topics for complete details before you perform a backup.
Task
  1. Connect to the server using an account with the BACKUP DATABASE system privilege.
    Note: For a multiplex database, you must connect to the coordinator.
  2. Run a BACKUP command, which backs up the following files:

    • 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: Types of Backups
Related concepts
Preparing for Backup
Related reference
BACKUP Statement