Sybase 12.4.2 manual Maintaining the backup log, Viewing the backup log in Sybase Central, 412

Getting information about backups and restores

20:07:00.000’, ...

DBA, InSF, Arch, A_partial2_yes_sf, ’’

Maintaining the backup log

It’s a good idea to clean up the backup log after you purge backup media. Use a text editor to do so. Be careful with your edits: once BACKUP or RESTORE records information in this file, it does not check its accuracy.

There is only one backup log on a server. The server must be able to read and write this file. The system administrator may want to limit access to this file by other users. If you are running more than one database server on a system, you should set the ASLOGDIR environment variable differently for each server, to produce separate backup logs.

Warning! Do not edit the backup log while a backup or restore is taking place. If you are modifying the file while BACKUP or RESTORE is writing to it, you may invalidate the information in the file.

Viewing the backup log in Sybase Central

The backup log contains information in raw, unsorted form. To see the information in a form that is easier to understand, you can view it in Sybase Central.

Note This feature is not yet supported.

Recording dbspace names

In the event that you ever need to use the RENAME option of RESTORE to move a database or one of its dbspaces, you need to know the name of every dbspace in the database. The dbspace names are in the SYSFILE table of every database, but you will not have this table available when you are restoring. For this reason, you should issue the following statement any time you back up your database:

select * from SYSFILE

412