Full Backups - Sql server

Full Backups.

Full backups, as the name suggests is a back up of the files and folders. Frequent full backups results in a faster restore. However, full backups are slow. The storage space requirement is also high. They are the most comprehensive type of backups and can also be scheduled for backing up the selected files and folders on a periodic basis.

Differential Backups

Differential backup backups up files that have been changed since the last backup. This reduces the time to backup since only changed files need to be restored. Restoring differential back up is faster and storage requirements are less. The list of files changed since the last back up is recorded in a catalogue file with .bkc extension