There are four ways to back up Sybase IQ data:
Database backup
Operating system-level backup
Virtual backup
Archive backup (for log files)
Sybase IQ provides four types of database backups:
Full backup makes a complete copy of the database.
Virtual backup copies all of the database except the table data from the IQ Store.
Incremental backup copies all transactions since the last backup of any type.
Incremental-since-full backup copies all transactions since the last full backup.
All these backup types fully back up the Catalog Store. In most cases, the Catalog Store is much smaller than the IQ Store. If the Catalog Store is larger than (or nearly as large as) the IQ Store, however, incremental backups of IQ are bigger than you may want or expect.
Incremental virtual backup is supported using the BACKUP statement.
Temporary Store data is not backed up. However, the metadata and any other information needed to recreate the Temporary Store structure is backed up.
Backing up the IQ Store
and Catalog Store
This procedure summarizes backup steps. Read the rest of this chapter for complete details before you perform a backup.
Connect to the server using an account with DBA privileges. For a multiplex database, you must connect to the write server.
Run the BACKUP command. For complete syntax, see the Sybase IQ Reference Manual.
It backs up the following files:
Catalog Store (SYSTEM dbspace file), typically named dbname.db
The transaction log file, which is required for system recovery, typically named dbname.log
All dbspace files of the IQ Store
Make a copy of the params.cfg file for each server. BACKUP does not back it up.
Save the lengths of the following files:
All dbspace files on the write server
IQ Temporary Store
