Source: https://patents.google.com/patent/US9703640B2/en
Timestamp: 2019-03-24 22:16:24
Document Index: 161095475

Matched Legal Cases: ['Application No. 12150113', 'Application No. 12150113', 'Application No. 201210003647', 'Application No. 201210003647', 'Application No. 2011', 'Application No. 2011']

US9703640B2 - Method and system of performing incremental SQL server database backups - Google Patents
US9703640B2
US9703640B2 US14/159,235 US201414159235A US9703640B2 US 9703640 B2 US9703640 B2 US 9703640B2 US 201414159235 A US201414159235 A US 201414159235A US 9703640 B2 US9703640 B2 US 9703640B2
US14/159,235
US20140136484A1 (en
2014-01-20 Application filed by Veritas Technologies LLC filed Critical Veritas Technologies LLC
2014-01-20 Priority to US14/159,235 priority patent/US9703640B2/en
2014-05-15 Publication of US20140136484A1 publication Critical patent/US20140136484A1/en
2017-07-11 Publication of US9703640B2 publication Critical patent/US9703640B2/en
This application is a continuation of U.S. patent application Ser. No. 12/986,666, entitled “METHOD AND SYSTEM OF PERFORMING INCREMENTAL SQL SERVER DATABASE BACKUPS”, filed Jan. 7, 2011, the entirety of which is incorporated herein by reference.
performing the incremental backup by conveying a request to a database server to perform a full backup of the database;
taking a snapshot of the database, the snapshot comprising a copy of a full image of the database;
retrieving one or more maps from the snapshot, said one or more maps including an identification of data which has changed since a prior backup, wherein the one or more maps include a differential change map (DCM) comprising a bitmap which indicates all data that has changed since the prior backup, a global allocation map comprising information about data extents that have been allocated, a shared global allocation map comprising information about mixed extents that have at least one unused page, and an index allocation map comprising information about extents that a table or index uses;
reading the one or more maps to determine if changed extents are allocated; and
retrieving the changed extents only if they are allocated;
retrieving the changed data utilizing the DCM to identify the changed data;
storing a copy of said one or more maps in association with the incremental backup file in the storage device;
2. The method as recited in claim 1, wherein in response to said request to perform the full backup, the method further comprises:
discarding said snapshot of the database; and
resetting the DCM to indicate no changed data as though a full backup operation was performed when the incremental backup file is stored in the storage device.
5. A non-transitory computer readable storage medium comprising program instructions to perform an incremental backup of a database, wherein when executed the program instructions are configured to:
perform the incremental backup by conveying a request to perform a full backup of the database;
take a snapshot of the database, the snapshot comprising a copy of a full image of the database;
retrieve one or more maps from the snapshot, said one or more maps including an identification of data which has changed since a prior backup, wherein the one or more maps include a differential change map (DCM) comprising a bitmap which indicates all data that has changed since the prior backup, a global allocation map comprising information about data extents that have been allocated, a shared global allocation map comprising information about mixed extents that have at least one unused page, and an index allocation map comprising information about extents that a table or index uses;
read the one or more maps to determine if changed extents are allocated; and
retrieve the changed extents only if they are allocated;
retrieve the changed data utilizing the DCM to identify the changed data;
store a copy of said one or more maps in association with the incremental backup file in the storage device;
6. The non-transitory computer readable storage medium as recited in claim 5, wherein in response to said request to perform the full backup the program instructions are further configured to:
discard said snapshot of the database; and
7. The non-transitory computer readable storage medium as recited in claim 5, wherein the program instructions are further configured to:
8. The non-transitory computer readable storage medium as recited in claim 7, wherein the program instructions are further configured to:
9. A system for performing an incremental backup of a database, the system comprising:
perform the incremental backup using a request to initiate a full backup; and
retrieve the changed data utilizing said DCM to identify the changed data;
10. The system as recited in claim 9, wherein in response to said request to perform the full backup the system is configured to:
discard the snapshot of the database; and
reset the DCM to indicate no changed data as though a full backup operation was performed when the incremental backup file is stored in the storage device.
11. The system as recited in claim 9, wherein the media server is further configured to:
US14/159,235 2011-01-07 2014-01-20 Method and system of performing incremental SQL server database backups Active US9703640B2 (en)
US12/986,666 Continuation US8635187B2 (en) 2011-01-07 2011-01-07 Method and system of performing incremental SQL server database backups
US20140136484A1 US20140136484A1 (en) 2014-05-15
US9703640B2 true US9703640B2 (en) 2017-07-11
JP (1) JP2012146301A (en)
2011-12-28 JP JP2011289030A patent/JP2012146301A/en active Pending
"Partial Cumulative Incremental Backups Offer Unique Advantages to Customers", Teradactyl LLC, 2007, 4 pages, http://web.archive.org/web/20120417095436/http://www.teradactyl.com/backup-knowledge/backup-documents/partialcumulativeincremental.pdf. [Retrieved Sep. 16, 2015].
"TeraMerge® Enables Multiple Level Synthetic Backup Consolidation for the Full Version of the True incremental Backup System®", Teradactyl LLC, 2007, 4 pages, http://web.archive.org/web/20120412052812/http://www.teradactyl.com/backup-knowledge/backup-documents/multimergeteramerge.pdf. [Retrieved Sep. 16, 2015].
"TeraMerge® Enables Single Level Synthetic Backup Consolidation for the Lite Version of the True incremental Backup System®", 2007, Teradactyl LLC, 6 pages, http://web.archive.org/web/20120417084705/http://www.teradactyl.com/backup-knowledge/backup-documents/singlelevelteramerge.pdf. [Retrieved Sep. 16, 2015].
Communication pursuant to Article 94(3) EPC in European Application No. 12150113.4, mailed Aug. 19, 2013, 5 pages.
Extended European Search Report for Application No. 12150113.4, mailed Jul. 5, 2012, 7 pages.
Notification of the First Office Action in Chinese Application No. 201210003647.0, mailed Mar. 30, 2016, 21 pages.
Notification of the Second Office Action in Chinese Application No. 201210003647.0, mailed Nov. 15, 2016, 6 pages.
Office Action in Japanese Patent Application No. 2011-289030, mailed Jul. 5, 2016, 7 pages.
Office Action in Japanese Patent Application No. 2011-289030, mailed Sep. 29, 2015, 8 pages.