Q

Creating a simple backup log

Sybase expert Mich Talebzadeh explains how to create a 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?

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 last published in March 2006

Dig Deeper on Linux backup and storage

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchDataCenter

SearchServerVirtualization

SearchCloudComputing

SearchEnterpriseDesktop

Close