Sybase 12.4.2 manual Displaying header information, 407

CHAPTER 11 Backup and Data Recovery

In an IQ Multiplex, you must restore on the write server in simplex mode, and synchronize the query server following the completion of the restore. For more information on multiplex restores, see Adaptive Server IQ Multiplex User’s Guide.

This restriction extends to any incremental restores you may need if your system crashes during recovery. If you need to recover from a system or media failure that occurs during a restore, you must do one of the following:

•Continue the original sequence of full and incremental restore operations, or

•Perform a full restore, followed by any incremental restores needed to fully recover your database.

The default database server startup setting -gd DBA makes DBA privileges a requirement for starting up a database. When the DBA runs RESTORE, the command automatically starts the database, gets the information it needs for the restore, and then stops the database. At the end of the restore, the command starts the database, issues a checkpoint, and stops it again. This procedure ensures that the DBA has exclusive write access throughout a restore.

When all incremental restores are complete, the DBA issues the START

DATABASE command again to allow other users access to the database.

Displaying header information

You can display the contents of the header file by using the RESTORE statement with the CATALOG ONLY option and no FILE clauses. The header file includes the following information:

•Database name

•Database type (Adaptive Server IQ or Adaptive Server Anywhere)

•Backup creation date

•Approximate number of tapes or disk files in the backup

•User who did the backup

•Backup type (full, incremental, or incremental-since-full)

•Medium (always Othr)

•Number, type, and size of dbspaces

407