Point-in-time restore using SQL VDI incremental backup over SQL VSS snapshot backup and recover
US10108497B1 · kind B1 · utility
Assignee
Inventors
Key dates
| Filing date | Sep 29, 2015 |
| Grant date | Oct 23, 2018 |
| Priority date | — |
| Expiry date | Oct 6, 2036 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/2477
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Embodiments for a system and method of performing restores of SQL database data, querying a backup history log to determine a sequence of full and incremental backups of the data, first restoring data from a full backup using a SQL volume shadow service (VSS) writer, placing the database into a recovering mode during the first restoring, and second restoring data from an incremental backup using a SQL virtual device interface (VDI) process while the database is in recovering mode until a stop signal is generated to form a hybrid restore process, where the stop signal comprises a STOPAT clause of the SQL VDI process that restores the database content until a given restore time.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.