Method and system of performing incremental SQL server database backups
US8635187B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Jan 7, 2011 |
| Grant date | Jan 21, 2014 |
| Priority date | — |
| Expiry date | Jan 7, 2031 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F2201/84
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A system, method, and medium for performing incremental backups of a Microsoft SQL server database. A snapshot of the database is created, and then a map identifying the changed extents is retrieved from the snapshot. The changed extents are then retrieved from the snapshot and stored in a backup storage device. For a restore operation, a full database backup file is written to a storage device and then the changed extents from a stored incremental backup file may be merged with the full backup file. Next, the database server is notified of the reconstructed file and then the reconstructed file is mounted by the database server as a live instance of the database.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.