System-Level Backups

The BACKUP DATABASE command is the most reliable method you can use to back up IQ data. If you prefer, you can perform a system-level backup, where you handle the entire data backup yourself. To ensure consistent catalog, metadata, and data, shut down the database before a system-level backup.

Follow the steps below when you perform a system-level backup. If you attempt to restore your database 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.

1. Shut Down the Database
   Shut down your SAP Sybase IQ database before performing a system-level backup.
2. Back Up the Correct Files
   Back up required files and optional files.
3. Restoring System-Level Backups
   Shut down the database server. On a multiplex, shut down all the secondary servers as well as the coordinator.