Sybase Adaptive Server IQ 12.4.2, Administration And Performance Manual

Page: 418 / 536

Restoring your databases
398
Restoring disk backup files
If you back up to disk and then move those files to tape, you must move them
back to disk files with the same names as when you created the backup.
Adaptive Server IQ cannot restore disk files that are moved to tape directly
from tape.
When you restore using the Sybase-provided backup and restore, you must
specify the same number of archive devices (disk files) for the restore as were
used to create the backup.
Restoring tape backup files
When restoring from tape, you must position the tape to the start of the IQ data.
RESTORE
does not reposition the tape for you.
When you restore using the Sybase-provided backup and restore, you must use
the same number of tape drives for the restore as were used to create the
backup(s) you are restoring.
Specifying files for an incremental restore
For an incremental restore, files you restore must match in number and size the
files they replace, for both the IQ and Catalog Stores.
Keeping the database unchanged between restores
If you are doing a set of incremental restores, and any user changes the
database before you finish restoring the complete set, the Restore program does
not let you restore the remaining incrementals. For example, if you have a set
consisting of a full restore and two incrementals, and a user’s write transaction
commits after the full restore but before you issue the second or third
RESTORE
command, you cannot proceed with the incremental restores.
Instead, you must restore the full backup and apply the incrementals again.
If the database has changed since the last restore and you try to do an
incremental restore, the following error occurs: