Sybase 12.4.2 manual Set, and the restore order, are as follows, 404

Restoring your databases

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 A1, A2, and A3. Tapes A1 and A2 contain the Catalog Store. This
	set must be restored first, and must be in the first device.

404