![background image](http://html1.mh-extra.com/html/sybase/adaptive-server-iq-12-4-2/adaptive-server-iq-12-4-2_administration-and-performance-manual_1416503398.webp)
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.
Summary of Contents for Adaptive Server IQ 12.4.2
Page 1: ...Administration and Performance Guide Adaptive Server IQ 12 4 2 ...
Page 16: ...xvi ...
Page 20: ...Related documents xx ...
Page 40: ...Compatibility with earlier versions 20 ...
Page 118: ...Troubleshooting startup shutdown and connections 98 ...
Page 248: ...Importing data by replication 228 ...
Page 306: ...Integrity rules in the system tables 286 ...
Page 334: ...Cursors in transactions 314 ...
Page 396: ...Users and permissions in the system tables 376 ...
Page 438: ...Determining your data backup and recovery strategy 418 ...
Page 484: ...Network performance 464 ...
Page 500: ...System utilities to monitor CPU use 480 ...
Page 514: ...Characteristics of Open Client and jConnect connections 494 ...
Page 536: ...Index 516 ...