Systems and methods for performing backups of a server database
Systems and methods for performing differential and full data protection operations. Parameters that define minimum, interval, and maximum values are provided to an agent. These values relate to changes in the data or in a database. The agent monitors the database and backups are triggered in accordance with these values. A differential backup is not performed until the minimum value is reached and differential backups are performed only after subsequent intervals are reached. A full backup is performed once the maximum value is reached.
1. A method for performing a data protection operation for a database, the method comprising:
setting parameters related to changes in the database, the parameters including a minimum value, a maximum value, and an interval value, wherein each of the parameters relates to modified pages in the database;
querying the database to determine a change value for the database, wherein the change value is a modified page count that identifies a number of pages that have changes in the database; and
performing a differential backup or a full backup based on an evaluation of the change value relative to the parameters, wherein the differential backup is performed:
when the change value exceeds the minimum value and is below a combination of the minimum value and the interval value, and
when the change value exceeds a combination of the minimum value and the interval value and is below the maximum value.
2. The method of claim 1 , further comprising not performing a differential backup when the change value is less than the minimum value.
3. The method of claim 1 , further comprising performing a full backup when the change value exceeds the maximum value.
4. The method of claim 1 , further comprising querying the database repeatedly to determine a current value of the change value.
5. The method of claim 1 , further comprising performing a differential backup when the change value is greater than a last differential backup page count plus the interval value and the change value is less than the maximum value.
6. The method of claim 1 , further comprising sending a trigger to a backup server to perform the differential backup or the full backup based on the evaluation.
7. The method of claim 6 , further comprising scheduling a workorder to perform the full backup or the differential backup.
8. A non-transitory computer readable medium comprising instructions for executing a method for performing a data protection operation for a database, the method comprising:
setting parameters related to changes in the database, the parameters including a minimum value, a maximum value, and an interval value, wherein each of the parameters relates to modified pages in the database;
querying the database to determine a change value for the database, wherein the change value is a modified page count that identifies a number of pages that have changes in the database; and
performing a differential backup or a full backup based on an evaluation of the change value relative to the parameters, wherein the differential backup is performed:
when the change value exceeds the minimum value and is below a combination of the minimum value and the interval value, and
when the change value exceeds a combination of the minimum value and the interval value and is below the maximum value.
9. The non-transitory computer readable medium of claim 8 , further comprising not performing a differential backup when the change value is less than the minimum value.
10. The non-transitory computer readable medium of claim 8 , further comprising performing a full backup when the change value exceeds the maximum value.
11. The non-transitory computer readable medium of claim 8 , further comprising querying the database repeatedly to determine a current value of the change value.
12. The non-transitory computer readable medium of claim 8 , further comprising performing a differential backup when the change value is greater than a last differential backup page count plus the interval value and the change value is less than the maximum value.
13. The non-transitory computer readable medium of claim 8 , further comprising sending a trigger to a backup server to perform the differential backup or the full backup based on the evaluation.
14. The non-transitory computer readable medium of claim 13 , further comprising scheduling a workorder to perform the full backup or the differential backup.