Sybase 12.4.2 User Manual
Page 424
Restoring your databases
404
To determine the correct order, you need the information about backup files
that is stored in the backup log. See “Getting information about backups and
restores” for the content and location of this file.
Restore backups as follows:
•
If your database is corrupt, or if you are moving any files to a new location,
you must restore a
FULL
backup.
•
If your most recent backup is a
FULL
backup, or if you need to restore a
database to the state that existed before any existing incremental(s) were
made, restore the full backup only.
•
If you have an
INCREMENTAL_SINCE_FULL
backup that precedes the
database failure, first restore from the last
FULL
backup, and then restore
the
INCREMENTAL_SINCE_FULL
backup.
•
If you do not have an
INCREMENTAL_SINCE_FULL
backup, but you have
performed one or more
INCREMENTAL
backups since your last
FULL
backup, first restore the
FULL
backup, and then restore the
INCREMENTAL
backups in the order in which they were made.
Within a given backup, the order in which you restore tapes is also important.
In particular, you need to keep track of the order of tapes in each backup tape
set, that is, the set of tapes produced in a given backup on a given archive
device:
•
You must restore the tape set that contains the backup of the Catalog Store
first, and it must be on the first archive device.
•
Within each set, you must restore tapes in the order in which they were
created.
•
You cannot interleave sets; each set must be restored before you can
restore another set.
•
After the first set, the order in which sets are restored does not matter, as
long as it is correct within each set.
Use the same number of drives to restore as were used to produce the backup,
so that you do not accidentally interleave tapes from different sets.
Example
Assume that you are restoring a full backup, in which you used three archive
devices, and thus produced three tape sets, A, B, and C. The contents of each
set, and the restore order, are as follows:
Set A
Tapes A
1
, A
2
, and A
3
. Tapes A
1
and A
2
contain the Catalog Store. This
set must be restored first, and must be in the first device.