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 coordinator.
Run the BACKUP command. For complete syntax, see the BACKUP statement in Chapter 1, “SQL Statements,” in Reference: Statements and Options.
It backs up the following files:
The catalog store (SYSTEM dbspace file), typically named dbname.db
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 coordinator
IQ temporary store
