Differential Backup - This is similar to full backup in that it stores both the data and the transaction records.To keep the backup file as small as possible, the previous transaction log details are deleted once a new backup record is made. Transaction Log - Only the transaction logs are saved as the backup in this method.Full Backup - This method takes a lot of time as the full copy of the database is made including the data and the transaction records.The different methods of backup in a database are: Either way, the database data may be corrupted and backup may be required. Catastrophic Event - A catastrophic event can be a natural calamity like a flood or earthquake or deliberate sabotage such as hacking of the database. ![]() So, it is important to periodically change them. These hard drives may sometimes malfunction leading to database corruption. The database is stored on multiple hard drives across various locations. Hardware Failure - This can also lead to loss of data in a database.To rectify the error, the database needs to be restored to the point in time before the error occured. User Error - Normally, user error is the biggest reason of data destruction or corruption in a database.There can be multiple reasons of failure in a database because of which a database backup and recovery plan is required. ![]() Transaction logs are also stored in the backup along with the database data because without them, the data would be useless. Using this backup, the database can be recovered as it was before the failure.ĭatabase backup basically means that a duplicate of the database information and data is created and stored in backup server just to be on the safe side. ![]() It is imperative to have a backup of the database in case the original is corrupted or lost because of any reason.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |