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,
Chris Keating 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' )
BACKUP DATABASE DIRECTORY 'c:\\temp' TRANSACTION LOG TRUNCATE;