Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Backup

Hello community,

I´m using Sybase Central to backup my ASA databases but I can´t find an option to truncate the log after backup is done. I´m running a complete backup every day. Someone knows how?

Thanks in advance,

SAP Legend

Former Member
replied

The statement that I recommended previously would work - that is the SQL that would be executed to truncate the log.As a reminder, that statement was:

BACKUP DATABASE DIRECTORY ''

TRANSACTION LOG ONLY

TRANSACTION LOG TRUNCATE;

Of course, you could create a database EVENT and do the backup and truncate in a single step. For example:

CREATE EVENT ScheduledBackupEvent

SCHEDULE "daily_backup" BETWEEN '02:00' AND '02:59' ON ( 'Sunday', 'Monday', 'Tuesday', 'Wednesday', 'Thursday', 'Friday', 'Saturday' )

HANDLER

BEGIN

    BACKUP DATABASE DIRECTORY 'c:\\temp' TRANSACTION LOG TRUNCATE;

END;

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question