Types of Backup
Backup Agent supports the
following types of backups:
- Database full backup .
Backs up the entire database including the transaction log .
- Database differential backup.
Backs up the new added or modified data since last full backup. A full
database backup is required before you perform a differential backup .
- Transaction log backup
. Backs up the transaction log files of a database . By creating
transaction log backups, a database can be restored to any point in time
contained within the sequence of transaction logs, right up to the point of
failure .
Note : If the database recovery modal is
"Simple" , it can do transaction log backup on this database.
When a Full Backup Is Required
When to Perform a Differential Backup
Creating transaction log backups