Backup - Sybase

Topics | How To | Related Topics


Overview

Supported Backup Types

Sybase Backup Jobs

Backup Considerations

Advanced Backup Options


Overview

Plan your backup jobs for this agent by reviewing the following information:


Supported Backup Types

This agent supports the following backup types:


Sybase Backup Jobs

This agent has the following unique functionality. The Sybase iDataAgent backs up very specific sets of data depending upon what type of operation you choose. Review the following information to understand exactly what will be backed up when you perform a backup job at the indicated level.

Transaction Log Backups

A transaction log backup is a backup of the transaction log of the database. This backup captures the transaction log which contains a record of all transactions whether the transaction was committed or not. Transaction log backups are consistent to the start time of the backup.

The use of transaction log backups make point in time recovery possible. You can restore to any point in time within the transaction log. If you use only full and differential backups, you will be able to restore to the time of the backup, but not to a point in time between backups.

A transaction log backup is similar to a traditional incremental backup you might perform on a file system because the transaction log backup contains only the new changes since the full or another transaction log backup.

Each time a transaction log is backed up it is truncated to the exact time of the backup. No checkpoint is issued at this time, therefore dirty pages are not written to disk before or after a transaction log backup. If there are dirty pages, any completed transactions will need to be rolled forward if a transaction log restore is performed. Any transactions that are not completed at the time a transaction log backup is performed are rolled back during a restore involving a transaction log backup.

Backing up the Transaction Log of a Damaged Database (Do Not Truncate Log)

In the scenario of a database failure where it is unacceptable to lose any data, you will want to restore to the point of failure. To do so means you will need to capture all transaction log events that occurred after the last backup job was run.


Backup Considerations

Before performing any backup procedures for this agent, review the following information:

Back to Top