Abstract:
Databases hold cloud data and applications, and cloud-hosted services and apps must support more
data. Therefore, the backup and recovery capabilities of the database are crucial. Regular backups of
structured and stored data can reduce data loss and corruption. Administrators restore the database
from a backup in the event of a hardware failure, data loss due to bugs, or other issues. The correct
methods and features are important to the database administrator and user to apply the right technique
at right time. The aim of the study incorporates identifying the available techniques of database backup
and recovery with the implementation method. As a result, we can distinguish between the types of
backup such as full, incremental, and differential, as well as recovery techniques such as log recovery
and shadow paging. Additionally, the results indicated the adoption of MySQL and NoSQL backup and
recovery methodologies. The result also showed the implementation of backup and recovery techniques
of MySQL and NoSQL. This could be a solution to database backup and recovery issues if we use the
appropriate approach and functionality.
