Select Archive Devices

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

SAP 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 medium for file system backup. 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, use multiple tape drives. Use Digital Linear Tape (DLT) drives, if they are supported for your platform.
• Platform-specific Backup Requirements
  Be aware of backup requirements for AIX and IBM Linux.
• Limit on the Number of Backup Devices
  Specify multiple TO clauses in the BACKUP statement to parallelize the backup operation.
• Backup Guidelines
  Keep backup commands small. Large numbers of devices increase I/O and hardware contention.