Backup refers to storing a copy of original data separately. | Recovery refers to restoring the lost data in case of failure. |
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. |
In simple backup is the replication of data. | In simple recovery is the process to store the database. |
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. |
It helps in improving data protection. | It helps in improving the reliability of the database. |
Backup makes the recovery process more easier. | Recovery has no role in data backup. |
The cost of backup is affordable. | The cost of recovery is expensive. |
It's production usage is very common. | It's production usage is very rare. |
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. |
Backup is not created automatically | There is automatic generation of restore points by your computer. |
A backup stores copies of the files in a location that is external to it. | A restore is carried out internally on your computer. |
Backup requires extra storage space. | Restore is internal so it does not require extra external storage space. |
Backup offers a means of recovery. | Recovery aims to guarantee the atomicity of the transaction and data. |