Method and apparatus for dynamically backing up database files
View Patent ↗A method and apparatus for backing up a storage system, e.g., one or more disk drives. In one embodiment, an apparatus utilizes a volume snapshot service (VSS) to create a snapshot image file of a computer's storage system and then subsequently reads the data blocks contained in the snapshot image file. A determination of the number of modified data blocks, i.e., the data blocks that have changed since a last backup operation, is made. The apparatus estimates a backup size from the number of modified data blocks and subsequently determines if the estimated backup size exceeds a predetermined threshold. In the event the predetermined threshold is exceeded, a backup operation is conducted.
1. A method for backing up a storage system storing a database, comprising:
utilizing a volume snapshot service (VSS) to create a snapshot image file of said storage system, wherein
said snapshot image file includes a copy of said database created without invoking database activity, and
said snapshot image file contains a SQL bitmap;
reading data blocks of said copy of said database in said snapshot image file;
ascertaining a number of modified data blocks, wherein
said modified data blocks are said data blocks that have changed since a last backup operation,
said ascertaining comprises contrasting said SQL bitmap to an original bitmap to determine said number of said modified data blocks, and
said original bitmap represents data blocks from said last backup operation;
estimating a backup size from said number of said modified data blocks;
determining if said backup size exceeds a predetermined threshold at or below which no backup operation is to be conducted; and
conducting a backup operation in the event said predetermined threshold has been exceeded.
2. The method of claim 1 , wherein said utilizing step can be executed according to a predetermined periodic schedule.
3. The method of claim 1 , wherein said estimating step further comprises:
obtaining a sum of said number of said modified data blocks; and
multiplying said sum by a conversion factor to calculate a corresponding amount of data size.
4. The method of claim 3 , wherein said conversion factor is 8192 bytes/block.
5. The method of claim 1 , wherein said reading step further comprises reading said data blocks from said SQL bitmap.
6. The method of claim 1 , wherein said data blocks are 8 kilobyte SQL blocks.
7. The method of claim 1 , wherein said predetermined threshold is an adjustable threshold.
8. The method of claim 1 , wherein said backup operation is a backup snapshot image.
9. The method of claim 1 , wherein the step of conducting a backup operation in the event said predetermined threshold has been exceeded includes wherein the backup operation so conducted is otherwise unscheduled.
10. An apparatus for backing up a storage system in a computer where said storage system is storing a database, comprising:
means for utilizing a volume snapshot service (VSS) to create a snapshot image file of said storage system, wherein
said snapshot image file includes a copy of said database created without invoking database activity, and
said snapshot image file contains a SQL bitmap;
means for reading data blocks of said copy of said database in said snapshot image file;
means for ascertaining a number of modified data blocks, wherein
said modified data blocks are said data blocks that have changed since a last backup operation,
said ascertaining comprises contrasting said SQL bitmap to an original bitmap to determine said number of said modified data blocks, and
said original bitmap represents data blocks from said last backup operation;
means for estimating a backup size from said number of said modified data blocks;
means for determining if said backup size exceeds a predetermined threshold at or below which no backup operation is to be conducted; and
means for conducting a backup operation in the event said predetermined threshold has been exceeded.
11. The apparatus of claim 10 , wherein said means for utilizing can be used to create said snapshot image file in accordance with a predetermined periodic schedule.
12. The apparatus of claim 10 , wherein said means for estimating further comprises:
means for obtaining a sum of said number of said modified data blocks; and
means for multiplying said sum by a conversion factor to calculate a corresponding amount of data size.
13. The apparatus of claim 12 , wherein said conversion factor is 8192 bytes/block.
14. The apparatus of claim 10 , wherein said means for reading further comprises means for reading said data blocks from said SQL bitmap.
15. The apparatus of claim 10 , wherein said data blocks are 8 kilobyte SQL blocks.
16. The apparatus of claim 10 , wherein said predetermined threshold is an adjustable threshold.
17. The apparatus of claim 10 , wherein said backup operation is a backup snapshot image.
18. The apparatus of claim 10 , wherein the backup operation conducted in the event said predetermined threshold has been exceeded is otherwise unscheduled.
19. A non-transitory computer readable storage medium storing program instructions executable to:
utilize a volume snapshot service (VSS) to create a snapshot image file of said storage system, wherein
said snapshot image file includes a copy of said database created without invoking database activity, and
said snapshot image file contains a SQL bitmap;
read data blocks of said copy of said database in said snapshot image file;
ascertain a number of modified data blocks, wherein
said modified data blocks are said data blocks that have changed since a last backup operation,
ascertaining said number of modified data blocks comprises contrasting said SQL bitmap to an original bitmap to determine said number of said modified data blocks, and
said original bitmap represents data blocks from said last backup operation;
estimate a backup size from said number of said modified data blocks;
determine if said backup size exceeds a predetermined threshold at or below which no backup operation is to be conducted; and
conduct a backup operation in the event said predetermined threshold has been exceeded.
20. The non-transitory computer readable storage medium of claim 19 , wherein said program instructions are further executable to:
obtain a sum of said number of said modified data blocks; and
multiply said sum by a conversion factor to calculate a corresponding amount of data size.
21. The non-transitory computer readable storage medium of claim 19 , wherein said predetermined threshold is an adjustable threshold.
22. The non-transitory computer readable storage medium of claim 19 , wherein said backup operation is a backup snapshot image.