Data Backup and Recovery

Regular and frequent backups are your only protection against database or device failure. Consider the performance implications of various backup options, and create an appropriate backup plan.

Backup plans depend on system load factors, database size, number of updates, and the relative importance of backup and recovery times. The length of time your organization can function without access to the data in your database determines the maximum recovery time. Run a full backup on a new database to provide a base point, then perform full and incremental backups on a fixed schedule. Consider time and storage requirements. Balance the time it takes to create the backup with the time it takes to restore the data.

• Database Backup
  The BACKUP DATABASE command backs up an SAP® Sybase® IQ database to one or more archive devices. Basic syntax identifies the type of backup you want to perform, and a TO clause that directs the output to an archive device:
• Database Validation
  Although BACKUP DATABASE ensures that the database is in a usable state, RESTORE DATABASE does not check for inconsistencies in restored data. Validate the database before a backup to ensure that the database you restore is stable.
• Performance Options
  BLOCK FACTOR specifies the number of blocks to write to the archive device at one time. This parameter also controls the amount of memory used for buffers during the backup, and has a direct impact on backup performance. The effects of the block factor are a function of disk subsystem speed, tape speed, and processor speed.
• Archive Devices
  Specific information about writing to different archive devices, including tape, disk, read-only hardware, and third-party products.
• Queries, Utilities, and Procedures
  Queries, utilities, and procedures return information about the tablespaces, dbspaces, and dbfiles in your database.
• Backup Scenarios
  Background information and code samples for routine, system-level, and virtual backups.
• Previous Backups
  Views, utilities, and procedures return details about previous backups.
• Backup Log
  SAP Sybase IQ logs events that occur during backups and restores to .backup.syb.