Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - Database Administration » Backup and Data Recovery » Backup and recovery tasks

Making a backup, continuing to use the original transaction log Next Page

Making a backup, deleting the original transaction log

If your database is not involved in replication, and if you have limited disk space on your online computer, you can delete the contents of the online transaction log (truncate the log) when you make a backup. In this case, you need to use every backup copy made since the last full backup during recovery from media failure on the database file.

For more information about when to use this type of backup, see A backup scheme for databases not involved in replication.

To make a backup, deleting the transaction log (Sybase Central)
  1. Start Sybase Central. Connect to the database as the DBA.

  2. Right-click the database and choose Create Backup Images from the popup menu.

    The Create Backup Images wizard appears.

  3. Click Next on the introductory page of the wizard.

  4. Select the database that you want to back up.

  5. On the next page, enter the name of a directory to hold the backup copies, and choose whether to perform a complete backup (all database files) or an incremental backup (transaction log file only).

  6. On the next page, select the option Truncate the Transaction Log.

  7. Click Finish to start the backup.

To make a backup, deleting the transaction log (SQL)