The protection workflow of application-aware log backups is as follows:
- Request to VM Direct Engine to perform backup
- Application-aware compatibility check (SQL permission, SQL status, VSS status, and so on)
- VM Direct Engine asks Microsoft App agent to perform transaction log backup
- Microsoft App agent will serially back up each database transaction log (using VDI) directly to target storage
- SQL Server truncates logs
- App agent provides database backup details, including discovered SQL assets, to VM Direct Engine
- VM Direct Engine parses VSS manifest and catalogs files and transaction logs
- Data Manager creates virtual machine PCS and its corresponding SQL PCS based on the backup results