Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » Database maintenance » Backup and data recovery » Backups for databases involved in synchronization and replication » Transaction log management

 

Renaming or truncating the transaction log (Sybase Central)

If your database is involved in synchronization or replication, rename the transaction log to create a new transaction log for the database. If your database is not involved in replication and you have limited disk space on your computer, truncate the transaction log.

Prerequisites

You must have BACKUP DATABASE privilege.

Context and remarks

If your database is involved in synchronization or replication, it is good practice to maintain copies of old transaction logs until you are certain they are no longer needed. Alternatively to renaming the transaction log, you can continue to use the existing transaction log when you back up your database.

If you truncate the transaction log during backup to delete the contents of the online transaction log, to recover your database from media failure on the database file you must use every backup copy made since the last full backup.

 Task

  1. In Sybase Central, use the SQL Anywhere 16 plug-in to connect to the database.

  2. Right-click the database and click Create Backup Images.

  3. Follow the instructions in the Create Backup Images Wizard.

    Option Action
    Rename the transaction log

    In the What do you want to do with the transaction log list, click Rename the transaction log.

    Truncate the transaction log

    In the What do you want to do with the transaction log list, click Truncate the transaction log.

Results

A backup is made and the transaction log is renamed or truncated.

 See also
Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0