Getting information about backups and restores

Sybase IQ provides a backup log, .backup.syb, to help you manage your backup media. This log is not used to create the backup or to restore the database; however, information describing the backup or restore is recorded in this file during both Backup and Restore.

NoteTo display only the information about a particular backup, you can run RESTORE with the CATALOG ONLY option. This option displays the header file for a backup from the media rather than from the file, so that the DBA can identify what is on the tape or file. See “Displaying header information”.