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.

Consider the performance implications of various backup options, and how they affect your ability to restore quickly in the event of a database failure.

• Scheduling Routine Backups
  Make a full backup of each database just after you create it, to provide a base point, and perform full and incremental backups on a fixed schedule thereafter. It is especially important to back up your database after any large number of changes.
• Designating Backup and Restore Responsibilities
  Backing up or restoring an SAP Sybase IQ database requires BACKUP DATABASE system privilege.
• Improving Performance for Backup and Restore
  The overall time it takes to complete a backup or restore a database depends largely on the strategy you choose for mixing full and incremental restores.