Skip to Content
avatar image
Former Member

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Oct 22, 2014 at 11:27 PM

    Try a "Create Backup Images...". You are likely creating an archive backup which is described in Sybase Central as "Backup database...". That type of archive creates a single file containing all of the files related to the database and is intended for storage to tape.

    There will be a page in the Create Backup Image wizard that will include the option to truncate the log.

    Add comment
    10|10000 characters needed characters exceeded

    • 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;