Point-in-time restore using SQL VDI incremental backup over SQL VSS snapshot backup and recover

摘要

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.