Data Backup, Recovery, and Archiving

To protect your data, schedule and perform regular backups. You can also use read-only hardware to archive non-modifiable data for easy access.

• Data Protection
  Sybase IQ provides a full set of features that protect you from two types of computer failure, and from database inconsistency.
• How to Back Up Databases
  Use the BACKUP command to back up your IQ database.
• Virtual Backups
  A virtual backup, sometimes called a NULL backup, backs up all of an IQ database except the IQ store table data.
• 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.
• Validating Your Database
  Backing up a database is useful only if the database is internally consistent.
• Restoring Your Databases
  Once you have created a database and made a full backup, you can restore the database when necessary. Sybase IQ restores the database to its state as of the automatic CHECKPOINT at the start of the backup.
• Getting Information about Backups and Restores
  Sybase IQ provides a backup log, .backup.syb, to help you manage your backup media.
• Determining Your Data Backup and Recovery Strategy
  To develop an effective strategy for backing up your system, you need to determine the best combination of full, incremental, and incremental-since-full backups for your site, and then set up a schedule for performing backups.
• Archiving Data with Read-Only Hardware
  Recent regulations such as the Health Insurance Portability and Accountability Act (HIPAA) and Sarbanes-Oxley Act specify rigid rules for data retention and compliance, requiring data archived in a immutable, easily accessible form.