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

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataCenter

SearchServerVirtualization

SearchCloudComputing

SearchEnterpriseDesktop

Close