Sybase 12.4.2 manual Getting information about backups and restores, Locating the backup log, 410

Getting information about backups and restores

If you are using a third-party backup product, the vendor information string needs to convey any information needed for the backup, such as the specification of devices, size of files, and stacker drives. See your vendor’s documentation for details.

Note Adaptive Server IQ does not permit unattended restore.

Getting information about backups and restores

Adaptive Server 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.

Note To 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”.

Locating the backup log

The.backup.syb file is in ASCII text format. Its location depends on the setting of environment variables at the time the server is started:

•On UNIX, the server tries to place it in the following locations, in this order:

•The directory specified by the ASLOGDIR environment variable.

•The directory specified by the HOME environment variable.

•The home directory as obtained from account information.

•The current directory (where the server was started).

If the file is placed in the "home" directory, it is prefixed with a "." in order to make it a hidden file.

410