Systems, apparatuses, and methods for assessing recovery viability of backup databases
View Patent ↗Apparatuses and methods for assessing the recovery viability of backup databases are provided. Some embodiments may include identifying a selected backup database set from the plurality of backup databases. In some embodiments, each backup database in the selected backup database set is associated with a database in a corresponding database set. Some embodiments may include triggering a first backup configuration check operation for each database in the corresponding database set. Some embodiments may include triggering a restore verification operation for each database in the selected backup database set. Some embodiments may include generating a recovery point objective score for each database in the selected backup database set. Some embodiments may include causing updating of a recovery point objective score interface based on the recovery point objective score for each database in the selected backup database set.
1. An apparatus configured for assessing recovery viability for a selected backup database, the apparatus comprising at least a processor, and a memory associated with the processor having computer coded instructions therein, with the computer coded instructions configured to, when executed by the processor, cause the apparatus to:
select a backup configuration check operation based at least in part on a database corresponding to a selected backup database;
trigger the backup configuration check operation for the database;
trigger a restore verification operation for the selected backup database; and
generate a recovery point objective score for the selected backup database, wherein the recovery point objective score is determined based at least in part on the backup configuration check operation and the restore verification operation.
2. The apparatus of claim 1 , wherein the restore verification operation comprises:
triggering generation of a temporary restore database based at least in part on the selected backup database.
3. The apparatus of claim 2 , wherein the restore verification operation further comprises:
determining if the temporary restore database is accessible, wherein determining if the temporary restore database is accessible comprises determining if data associated with the selected backup database can be read from the temporary restore database.
4. The apparatus of claim 3 , wherein, in an instance in which the data associated with the selected backup database can be read from the temporary restore database, the restore verification operation further comprises:
triggering deletion of the temporary restore database.
5. The apparatus of claim 1 , wherein the computer coded instructions are configured to, when executed by the processor, further cause the apparatus to:
generate a backup configuration check score for the database based at least in part on the backup configuration check operations; and
generate a restore verification status score for the selected backup database based at least in part on the restore verification operation.
6. The apparatus of claim 5 , wherein, in an instance in which the backup configuration check score is associated with a pass score and the restore verification status score is associated with a pass score, the recovery point objective score is associated with a pass score.
7. The apparatus of claim 5 , wherein, in an instance in which the backup configuration check score is associated with a fail score or the restore verification status score is associated with a fail score, the recovery point objective score is associated with a fail score.
8. The apparatus of claim 5 , wherein, in an instance in which the backup configuration check score is associated with a not applicable score and the restore verification status score is associated with a pass score, the recovery point objective score is associated with a warning score.
9. The apparatus of claim 5 , wherein, in an instance in which the backup configuration check score is associated with a pass score and the restore verification status score is associated with an acceptable score, the recovery point objective score is associated with an acceptable score.
10. The apparatus of claim 5 , wherein the computer coded instructions are configured to, when executed by the processor, further cause the apparatus to:
generate a recovery point objective score interface based at least in part on the recovery point objective score for the selected backup database, a restore verification status interface based at least in part on the restore verification status score for the selected backup database, or a backup configuration check interface based at least in part on the backup configuration check score for the database.
11. A method for assessing recovery viability for a selected backup database, the method comprising:
selecting a backup configuration check operation based at least in part on a database corresponding to a selected backup database;
triggering the backup configuration check operation for the database;
triggering a restore verification operation for the selected backup database; and
generating a recovery point objective score for the selected backup database, wherein the recovery point objective score is determined based at least in part on the backup configuration check operation and the restore verification operation.
12. The method of claim 11 , wherein the restore verification operation comprises:
triggering generation of a temporary restore database based at least in part on the selected backup database.
13. The method of claim 12 , wherein the restore verification operation further comprises:
determining if the temporary restore database is accessible, wherein determining if the temporary restore database is accessible comprises determining if data associated with the selected backup database can be read from the temporary restore database.
14. The method of claim 13 , wherein, in an instance in which the data associated with the selected backup database can be read from the temporary restore database, the restore verification operation further comprises:
triggering deletion of the temporary restore database.
15. The method of claim 11 , further comprising:
generate a backup configuration check score for the database based at least in part on the backup configuration check operations; and
generate a restore verification status score for the selected backup database based at least in part on the restore verification operation.
16. The method of claim 15 , wherein, in an instance in which the backup configuration check score is associated with a pass score and the restore verification status score is associated with a pass score, the recovery point objective score is associated with a pass score.
17. The method of claim 15 , wherein, in an instance in which the backup configuration check score is associated with a fail score or the restore verification status score is associated with a fail score, the recovery point objective score is associated with a fail score.
18. The method of claim 15 , wherein, in an instance in which the backup configuration check score is associated with a not applicable score and the restore verification status score is associated with a pass score, the recovery point objective score is associated with a warning score.
19. The method of claim 15 , wherein, in an instance in which the backup configuration check score is associated with a pass score and the restore verification status score is associated with an acceptable score, the recovery point objective score is associated with an acceptable score.
20. A computer program product for assessing recovery viability for a selected backup database, the computer program product comprising at least one non-transitory computer readable storage medium having computer executable code portions stored therein, the computer executable code portions comprising program code instructions configured to:
select a backup configuration check operation based at least in part on a database corresponding to a selected backup database;
trigger the backup configuration check operation for the database;
trigger a restore verification operation for the selected backup database; and
generate a recovery point objective score for the selected backup database, wherein the recovery point objective score is determined based at least in part on the backup configuration check operation and the restore verification operation.