System-Level Backups

The BACKUP command is the most reliable method you can use to back up IQ data. If you are careful to follow the correct procedures, you can use system-level backups for an IQ database.

You must follow these procedures when using system-level backups for backing up your IQ database. If you attempt to restore your IQ database files from a system-level backup without these safeguards in place, you are likely to cause data loss or inconsistency, either from activity in the database while the system-level backup occurred, or from missing files.

• Shut Down the Database
  Your IQ database must be shut down during a system-level backup. For details about performing system-level backup on multiplex systems, see Using Sybase IQ Multiplex.
• Back Up the Right Files
  Back up required files and optional files.
• Restoring from a System-Level Backup
  If you must restore from a system-level backup, you must ensure that database server is shut down, just as it was during the backup.