Bypassing backup operations for specified database types
Bypassing backup operations for specified database types is described. A system determines whether a database, of multiple databases associated with a database system, corresponds to a database type specified in a configuration file, in response to receiving a backup operation request. The system executes an incremental backup operation on changes made to the database since a selected time, for the backup operation request, if the database does not correspond to the database type specified in the configuration file. The system bypasses executing any backup operation on the database for the backup operation request if the database corresponds to the database type specified in the configuration file.
1. A system for bypassing backup operations for specified database types, the system comprising:
one or more processors; and
a non-transitory computer readable medium storing a plurality of instructions, which when executed, cause the one or more processors to:
determine whether a database, of a plurality of databases associated with a database system, corresponds to a database type specified in a configuration file, in response to receiving a backup operation request, the database type indicating a lack of a transaction log for the database, and the backup operation configured to perform a full backup operation if changes to the database since a previous backup cannot be determined;
execute an incremental backup operation on changes made to the database since a selected time, for the backup operation request, in response to a determination that the database does not correspond to the database type specified in the configuration file; and
bypass executing any backup operation on the database for the backup operation request in response to a determination that the database corresponds to the database type specified in the configuration file.
2. The system of claim 1 , wherein the plurality of instructions, when executed, further causes the processors to receive the configuration file from a system user.
3. The system of claim 1 , wherein the selected time is associated with a previous backup operation executed on the database.
4. The system of claim 1 , wherein the plurality of instructions, when executed, further causes the processors to execute the full backup operation on the database in response to receiving a subsequent backup operation request.
5. The system of claim 4 , wherein the subsequent backup operation request is based on a full backup schedule.
6. The system of claim 5 , wherein the full backup operation is executed on the database in response to a determination the subsequent backup operation request is based on the full backup schedule instead of an incremental backup schedule.
7. The system of claim 1 , wherein the backup operation request is based on an incremental backup schedule.
8. The system of claim 7 , wherein bypassing executing any backup operation on the database for the backup operation is performed without modifying the incremental backup schedule of the backup operation request.
9. The system of claim 1 , wherein the backup operation is further configured to perform the full backup operation if changes to the database cannot be determined as a result of the database being implemented using a simple recovery model.
10. A computer-implemented method for bypassing backup operations for specified database types, the method comprising:
determining whether a database, of a plurality of databases associated with a database system, corresponds to a database type specified in a configuration file, in response to receiving a backup operation request, the database type indicating a lack of a transaction log for the database, and the backup operation configured to perform a full backup operation if changes to the database since a previous backup cannot be determined;
executing an incremental backup operation on changes made to the database since a selected time, for the backup operation request, in response to a determination that the database does not correspond to the database type specified in the configuration file; and
bypassing executing any backup operation on the database for the backup operation request in response to a determination that the database corresponds to the database type specified in the configuration file.
11. The method of claim 10 , wherein the method further comprises receiving the configuration file from a system user.
12. The method of claim 10 , wherein the selected time is associated with a previous backup operation executed on the database.
13. The method of claim 10 , wherein the method further comprises executing the full backup operation on the database in response to receiving a subsequent backup operation request.
14. The method of claim 13 , wherein the subsequent backup operation request is based on a full backup schedule.
15. The method of claim 10 , wherein the backup operation request is based on an incremental backup schedule.
16. A computer program product, comprising a non-transitory computer-readable medium having a computer-readable program code embodied therein to be executed by one or more processors, the program code including instructions to:
determine whether a database, of a plurality of databases associated with a database system, corresponds to a database type specified in a configuration file, in response to receiving a backup operation request, the database type indicating a lack of a transaction log for the database, and the backup operation configured to perform a full backup operation if changes to the database since a previous backup cannot be determined;
execute an incremental backup operation on changes made to the database since a selected time, for the backup operation request, in response to a determination that the database does not correspond to the database type specified in the configuration file; and
bypass executing any backup operation on the database for the backup operation request in response to a determination that the database corresponds to the database type specified in the configuration file.
17. The computer program product of claim 16 , wherein the program code includes further instructions to receive the configuration file from a system user.
18. The computer program product of claim 16 , wherein the selected time is associated with a previous backup operation executed on the database.
19. The computer program product of claim 16 , wherein the program code includes further instructions to execute the full backup operation on the database in response to receiving a subsequent backup operation request.
20. The computer program product of claim 19 , wherein the backup operation request is based on an incremental backup schedule, and the subsequent backup operation request is based on a full backup schedule.