Search code examples
sybasesqlanywhere

Sybase Sql Anywhere Backup

Sybase Sql Anywhere:

When i backup a database while a transaction is stil active and i truncate the transaction log while backuping, what's the outcome?

  1. Transaction'd data changes are not in the backup
  2. Transaction'd data changes are in the truncated transaction log file

Thx.

Solution

  • Depends on your isolation level.

    Under typical circumstances the transaction would not be contained within the backup.

    Also, the transaction log will only truncate up to the oldest open transaction.