1. Backup :
Backup refers to storing a copy of original data which can be used in case of data loss. Backup is considered as one of the approach of data protection. Important data of the organization needs to be kept in backup efficiently for protecting valuable data. Backup can be achieved by storing copy of the original data separately or database on storage devices. There are various types of backups are available like full backup, incremental backup, Local backup, mirror backup etc.
Example of Backup can be SnapManager makes a backup of everything in database.
2. Recovery :
Recovery refers to restoring the 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 data base failures due to any reason then there is the chance of data loss, so in that case recovery process helps in improving the reliability of the database.
Example of Recover can be SnapManager recovers the data to the last transaction.
Difference between Backup and 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.|
Attention reader! Don’t stop learning now. Get hold of all the important CS Theory concepts for SDE interviews with the CS Theory Course at a student-friendly price and become industry ready.