Configuration stage - The configuration stage of self-service Application Direct backup consists of the following steps:
- The user creates a protection policy from Data Manager.
- Data Manager creates a Boost user and storage-unit on the storage.
- The application agent configures a lockbox with credentials on SQL.
![The image shows the Self-service Application Direct backup workflow](/static/media/9198938f-8c47-5a0e-82d9-6db6a62cd3f7/DAM-74b1ed56-fdae-4161-a710-0cf4d3b986b7/out/4446.025.png)
Figure 21. Self-service Application Direct backup workflow
Self-service Application Direct backup workflow (FULL)
Protect stage - The following steps show the self-service Application Direct SQL database backup flow.
![The image shows the Self-service Application Direct backup workflow (FULL)](/static/media/9198938f-8c47-5a0e-82d9-6db6a62cd3f7/DAM-74b1ed56-fdae-4161-a710-0cf4d3b986b7/out/4446.026.png)
Figure 22. Self-service Application Direct backup workflow (FULL)
- Protection triggered by DBA on SQL host.
- The app agent uses SQL VDI to back up SQL.
- The app agent moves data to DD series appliance using DD Boost.
- The Microsoft app agent catalogs the backup.
- Return backup results through ADM.
- Return backup discovery details (ADM).
- PowerProtect creates SQL PCS (Protection Copy Set) based on the backup results.
Self-service Application Direct backup workflow (LOG)
Protect stage - The steps below show the self-service Application Direct SQL log backup flow.
![The image shows the Self-service Application Direct backup workflow (LOG)](/static/media/9198938f-8c47-5a0e-82d9-6db6a62cd3f7/DAM-74b1ed56-fdae-4161-a710-0cf4d3b986b7/out/4446.027.png)
Figure 23. Self-service Application Direct backup workflow (LOG)
- Protection triggered by DBA on SQL host.
- The app agent uses SQL VDI to back up SQL.
- The app agent moves data to DD series appliance using DD Boost.
- The Microsoft app agent catalogs the backup.
- The SQL Server truncates the log.
(Repeat steps 2 through 5 for each database.)
- Return backup results through ADM.
- Return backup discovery details (ADM).
- PowerProtect creates SQL PCS (Protection Copy Set) based on the backup results.