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 Adaptive Server 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 an IQ multiplex database, you must run backups on the write server, but you may execute backups while the servers are all running in multiplex mode.