Types of Backups

There are four ways to back up SAP Sybase IQ data.

• Types of Database Backups
  SAP Sybase IQ provides four types of database backups:
• Backing Up the IQ Store and Catalog Store
  This procedure summarizes backup steps.
• Data in Backups
  BACKUP backs up committed data only.
• The Transaction Log In Backup, Restore, and Recovery
  SAP Sybase IQ uses the transaction log file during recovery from a system failure.
• 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.