Backup Scenarios

Background information and code samples for routine, system-level, and virtual backups.

• Routine Backups
  Code samples, background information, and tips for standard backup options.
• Cache Dbspace Backup
  If your installation uses the cache dbspace for direct-attached storage, follow best practices to avoid errors during backup.
• System-Level Backups
  The BACKUP DATABASE command is the most reliable method you can use to back up IQ data. If you prefer, you can perform a system-level backup, where you handle the entire data backup yourself. To ensure consistent catalog, metadata, and data, shut down the database before a system-level backup.
• Virtual Backups
  Virtual backups perform a full backup of the catalog store and select SAP Sybase IQ metadata, and metadata not specific to individual tables, including information specific to the freelist, backup, and checkpoint. Virtual backups do not back up table data and metadata in the IQ store. Use the VIRTUAL backup parameters as part of a full database backup.