Ask the Expert

Creating a simple backup log

Is there any database table in Sybase like backupset in MS SQLServer for recording Backup History? We use this table to display data for backup histories. We have a log on Sybase backup server but that does not help me. I need a similar kind of table which stores backup information automatically. Do we have any automated recording of backup events (history) in Sybase? Or do we have to design our own table and populate it order to do the same?

    Requires Free Membership to View

Sybase ASE writes backup information to backup errorlog which is, by default, in the ASE's install directory. You should be able to write a small routine that dumps the database and writes the backup info like START TIME, END TIME, TIME TAKEN, NUMBER OF STRIPES USED and SIZE into a database table. You can design your own table and use ASE scheduler to start your backup job.

This was first published in March 2006

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.