Types of Backups

There are four ways to back up Sybase IQ data.

• Types of Database Backups
  Sybase IQ provides four types of database backups:
• Backing Up the IQ Store and Catalog Store
  Read the rest of the backup topics for complete details before you perform a backup.
• Data in Backups
  BACKUP backs up committed data only.
• The Transaction Log In Backup, Restore, and Recovery
  Sybase IQ uses the transaction log file during recovery from a system failure.
• Making a Live Backup of a Transaction Log
  You can make a live backup of the transaction log using the dbbackup utility with the -l option.
• Distribution of Backup Data
  BACKUP always makes a full backup of the catalog store on the first archive device, and then backs up the data from the IQ store in parallel across all of the devices you specify.
• Ensure that your Database is Consistent
  Although BACKUP does check that all necessary files are present before backing up your database, it does not check internal consistency.