Select Archive Devices

You can back up any IQ database onto magnetic tape or disk, including WORM devices.

Sybase IQ supports backup and restore using multiple tape drives at near device speeds, or to multiple disks if disk striping is in use. Specify the backup device name in the archive_device parameter of the BACKUP command.

• Disk Backup Requirements
  Disk backups must go to a file system; raw disk is not supported as a backup medium. All disks on a redundant array of independent devices (RAID) device are treated as a single device.
• Tape Backup Requirements
  If you regularly back up large databases, you should use DLT drives, if they are supported for your platform. In any case, Sybase recommends that you use multiple tape drives.
• Platform-specific Backup Requirements
  Be aware of backup requirements for AIX and IBM Linux.
• Limits on the Number of Backup Devices
  When using the BACKUP command of Sybase IQ, users can parallelize the operation to multiple devices by specifying multiple TO clauses. The backup statement has an upper limit of 36 on the device numbers. If the upper limit is exceeded, the statement produces an error.
• Corrective Actions for Future Backups
  Users must create future backups using 36 or fewer TO clauses in a BACKUP command, a limit that will be enforced in future versions of Sybase IQ.