Sybase 12.4.2 manual Backing up your database, Types of backups, Data in backups, 378

Backing up your database

Backing up your database

You use the BACKUP command to back up your IQ database. Backup includes both the Adaptive Server IQ data (the IQ Store) and the underlying Adaptive Server Anywhere database (the Catalog Store)

Backup runs concurrently with read and write operations in the database. By contrast, during a restore no other operations are allowed on that database.

You must be connected to a database in order to back it up. The BACKUP command has no way to specify another database.

For an IQ multiplex database, you must run backups on the write server, but you may execute backups while the servers are all running in multiplex mode. For more information about multiplex backups, see Adaptive Server IQ Multiplex User’s Guide.

Types of backups

Adaptive Server IQ provides three types of backups:

•Full backup makes a complete copy of the database.

•Incremental backup copies all transactions since the last backup of any type.

•Incremental-since-full backup copies all transactions since the last full backup.

All three backup types fully back up the Catalog Store. In most cases, the Catalog Store is much smaller than the IQ Store. If the Catalog Store is larger than (or nearly as large as) the IQ store, however, incremental backups of IQ will be bigger than you may want or expect.

Temporary Store data is not backed up. However, the meta data and any other information needed to recreate the Temporary Store structure is backed up.

Data in backups

BACKUP backs up committed data only. Backups begin with an automatic checkpoint. At this point, the backup program determines what data will be backed up. It backs up the current snapshot version of your database as of the time of this checkpoint. Any data that is not yet committed when this checkpoint occurs is not included in the backup.

378