35.5k views
3 votes
Recovery methods from a database failure​

User Raveturned
by
5.0k points

1 Answer

4 votes

Answer:

Step-by-step explanation:

If we make a database backup we could recover our data if something fails, for example, in a system crash, transaction errors, viruses, incorrect commands execution, etc.

There are some types of backups:

Full database backup: Everything is safe in this backup.

Differential backup: this backup only stores the changes in the full backup.

Transaction log backup: contains all transactions that had happened to the database.

User Krishna Kinnera
by
5.0k points