Diff types of backup

Question

Accepted Answer

Different types of backup include full, incremental, differential, and snapshot backups.

Full backup: A complete backup of all data and files.
Incremental backup: Only backs up the changes made since the last backup.
Differential backup: Backs up all changes made since the last full backup.
Snapshot backup: Captures the state of the database at a specific point in time.

Accepted Answer

There are mainly four types of backup available in SQL Server. i) Full Backup, ii) Differential Backup,iii) Transaction Log Backup, iv) Tail Log Backup

Full Backup :- These backups create a complete backup of your database as well as part of the transaction log.

Differential Backup :- These backups create a backup of all the data that has been changed since the last backup is backed up.

Transaction Log Backup:- Transaction log backup contains the information about all the transactions that are present in the transaction log of the database.

Tail Log Backup:- The tail log backup is a special type of transaction log backup. As the name implies, it backs up the tail of the log,meaning those log records that have yet to be backed up as part of the normal transaction log backup process.

Diff types of backup

Popular interview questions of Database Administrator DBA