The protection workflow of application-aware database backups is as follows:
- Request to VM Direct Engine agent to perform backup
- Application-aware compatibility check (SQL permission, SQL status, VSS status, and so on)
- VM Direct Engine takes VADP snapshot with quiesce option which will internally trigger VMware's own VSS workflow
- VM Direct Engine gets changed blocks from VADP
- VM Direct Engine starts data transfer to target storage
- VM Direct Engine retrieves VSS manifest (metadata) from vSphere using VADP API and uploads it to the guest virtual machine
- VM Direct Engine tells Microsoft app agent to catalog the backup
- App agent parses VSS manifest and catalogs databases quiesced during step 3 under its own directory structure on storage
- App agent provides database backup details, including discovered SQL assets, to VM Direct Engine
- Data Manager creates virtual machine protection copy set (PCSt) and corresponding SQL PCS based on the backup results