Sybase 12.4.2 - Manual (Page 398)

Backing up your database
378
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.