Difference between Backup and Recovery
1. Backup: Backup refers to storing a copy of original data which can be used in case of data loss. Backup is considered one of the approaches to data protection. Important data of the organization needs to be kept in backup efficiently for protecting valuable data. Backup can be achieved by storing a copy of the original data separately or in a database on storage devices. There are various types of backups are available like full backup, incremental backup, Local backup, mirror backup, etc. An example of a Backup can be SnapManager which makes a backup of everything in the database.
2. Recovery: Recovery refers to restoring lost data by following some processes. Even if the data was backed up still lost so it can be recovered by using/implementing some recovery techniques. When a database fails due to any reason then there is a chance of data loss, so in that case recovery process helps in improve the reliability of the database. An example of Recover can be SnapManager which recovers the data from the last transaction.
Difference between Backup and Recovery:
S. No. | BACKUP | RECOVERY |
---|---|---|
01. | Backup refers to storing a copy of original data separately. | Recovery refers to restoring the lost data in case of failure. |
02. | So we can say Backup is a copy of data which is used to restore original data after a data loss/damage occurs. | So we can say Recovery is a process of retrieving lost, corrupted or damaged data to its original state. |
03. | In simple backup is the replication of data. | In simple recovery is the process to store the database. |
04. | The prior goal of backup is just to keep one extra copy to refer in case of original data loss. | The prior goal of recovery is retrieve original data in case of original data failure. |
05. | It helps in improving data protection. | It helps in improving the reliability of the database. |
06. | Backup makes the recovery process more easier. | Recovery has no role in data backup. |
07. | The cost of backup is affordable. | The cost of recovery is expensive. |
08. | It’s production usage is very common. | It’s production usage is very rare. |
09. | Example of Backup can be SnapManager makes a backup of everything in database. | Example of Recover can be SnapManager recovers the data to the last transaction. |
10. | Backup is not created automatically. | There is automatic generation of restore points by your computer. |
11. | A backup stores copies of the files in a location that is external to it. | A restore is carried out internally on your computer. |
12. | Backup requires extra storage space. | Restore is internal so it does not require extra external storage space. |
13. | Backup offers a means of recovery. | Recovery aims to guarantee the atomicity of the transaction and data. |
Contact Us