Problem solve Get help with specific problems with your technologies, process and projects.

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.

Dig Deeper on Linux servers

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.

Please create a username to comment.