One of the regular tasks of an administrator is to take system backups periodically. Whenever there is a disaster, administrators sometimes rely on the backup to restore the data with some data loss, that is, the data that was created after the backup until the disaster or system crash.
Backup is usually of three types:
Full backup: This backs up the whole database. In this, snapshot of the database, the complete current state is taken. Usually, a full backup is scheduled once in a week.
Incremental: This is an incremental backup of the data that has changed since the last backup.
Differential: This is the backup of the transaction that has happened since the last full backup.
