Topics | How To | Related Topics
Plan your backup jobs for this agent by reviewing the following information:
This agent supports the following backup types:
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.
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.
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.
Before performing any backup procedures for this agent, review the following information:
If you have created subclients for a database, you can create a complete backup of the database by backing up these subclients. If you have created a group of selected subclients for the database, you must back up all of these subclients to create a complete backup. If you have created separate subclients for the log file, and if these subclients are not included with the subclients defined for databases or subsets, then the subclients for these files must also be backed up to create a complete backup.
Multiple streams are supported for data protection and recovery operations with this agent; however, before utilizing multiple streams, you should understand how their use affects operations. For more information, see Streams.