Backing up your database

You use the BACKUP command to back up your IQ database. Backup includes both the Sybase IQ data (the IQ store) and the underlying SQL Anywhere database (the catalog store).

Backup runs concurrently with read and write operations in the database. By contrast, during a restore no other operations are allowed on that database.

You must be connected to a database in order to back it up. The BACKUP command has no way to specify another database.

For information about backing up multiplex databases, see Chapter 5, “Backing Up and Restoring Data in a Multiplex Environment,” in Using Sybase IQ Multiplex.