Sybase 12.4.2 Manuale Utente

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.

Adaptive Server IQ does not permit unattended restore.

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.

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

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.