SYSTEMS AND METHODS FOR PERFORMING BACKUPS OF A SERVER DATABASE

• US 20200133784A1
• Filed: 10/25/2018
• Published: 04/30/2020
• Est. Priority Date: 10/25/2018
• Status: Active Grant

• Current Assignee: Emc IP Holding Company LLC (Dell Technologies Inc.)
• Original Assignee: Emc IP Holding Company LLC (Dell Technologies Inc.)
• Inventors: Bhanushali, Jigar Premajibhai, Yadav, Sunil
• Granted Patent: US 11,263,085 B2
• Time in Patent Office: Days
• CPC Class Codes: G06F 11/1451 by selection of backup contents
• CPC Class Codes: G06F 11/1469 Backup restoration techniques
• CPC Class Codes: G06F 11/302 where the computing system component is a software system
• CPC Class Codes: G06F 16/122 using management policies backup systems G06F11/1446; file migration policies for HSM systems G06F16/185
• CPC Class Codes: G06F 16/2365 Ensuring data consistency and integrity
• CPC Class Codes: G06F 16/24564 Applying rules; Deductive queries
• CPC Class Codes: G06F 2201/84 Using snapshots, i.e. a logical point-in-time copy of the data
• CPC Class Codes: G06F 2201/88 Monitoring involving counting

Abstract

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.

Claims

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;

querying the database to determine a change value for the database; and

performing a differential backup or a full backup based on an evaluation of the change value relative to the parameters.

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 differential backup when the change value is greater than the minimum value.

4. The method of claim 3, further comprising performing a differential backup when the change value is greater than the minimum value and less than the maximum value.

5. The method of claim 4, further comprising performing a full backup when the change value exceeds the maximum value.

6. The method of claim 1, further comprising querying the database repeatedly.

7. The method of claim 1, wherein the change value is a modified page count.

8. 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.

9. 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.

10. The method of claim 9, further comprising scheduling a workorder to perform the full backup or the differential backup.

11. A method for backing up a database with a backup server and an agent operating on a client machine, the method comprising:

setting parameters for the database by the server, the parameters including a minimum value, an interval value, and a maximum value;

performing a query, by the agent, to the database to determine a modified page count;

performing a differential backup when the modified page count is greater than the minimum value;

performing a full backup when the modified page count is greater than the maximum value; and

performing a differential backup when the modified page count is greater than a last differential modified page count plus the interval value, wherein the last differential modified page count is the modified page count at a time when the last differential backup was performed.

12. The method of claim 11, wherein the parameters are set for a plurality of databases.

13. The method of claim 11, wherein the query is a native query associated with the database.

14. The method of claim 11, further comprising performing the query at regular intervals.

15. The method of claim 11, further comprising resetting the modified page count after performing the full backup.

16. The method of claim 11, further comprising receiving the parameters from the backup server.

17. A non-transitory computer readable medium comprising instructions for executing a method for backing up a database with a backup server and an agent operating on a client machine, the method comprising:

setting parameters for the database by the server, the parameters including a minimum value, an interval value, and a maximum value;

performing a query, by the agent, to the database to determine a modified page count;

performing a differential backup when the modified page count is greater than the minimum value;

performing a full backup when the modified page count is greater than the maximum value; and

performing a differential backup when the modified page count is greater than a last differential modified page count plus the interval value, wherein the last differential modified page count is the modified page count at a time when the last differential backup was performed.

18. The computer readable medium of claim 17 wherein the query is a native query associated with the database.

19. The computer readable medium of claim 17, further comprising performing the query at regular intervals.

20. The computer readable medium of claim 17, further comprising resetting the modified page count after performing the full backup.