PowerProtect Data Manager 19.9 Microsoft Application Agent SQL Server User Guide

Microsoft SQL operational log files for backup and restore operations

The Microsoft application agent uses the SQL operational log file <program_name>_{cent|self}_<date_and_time>_<trace_ID>.log for centralized and self-service backup and restore operations integrated with PowerProtect Data Manager on a SQL host.

For example:

• Operational log for centralized SQL backup: ddbmsqlsv_cent_20210729193042_TRACE_ID81adc95d817a1151EXEC_IDa15c4d5c6cc3be6d.log
• Operational log for centralized SQL restore: ddbmsqlrc_cent_20210729193042_TRACE_ID81adc95d817a1151EXEC_IDa15c4d5c6cc3be6d.log
• Operational log for self-service SQL backup: ddbmsqlsv_self_20210729193042_TRACE_ID81adc95d817a1151EXEC_IDa15c4d5c6cc3be6d.log
• Operational log for self-service SQL restore: ddbmsqlrc_self_20210729193042_TRACE_ID81adc95d817a1151EXEC_IDa15c4d5c6cc3be6d.log

The operational logs are deleted after 15 days by default. To override this default behavior and have the logs deleted before 15 days, you can add the parameter setting purgeOperationalLogDays = <number_of_days> in the file <installation_path>\MSAPPAGENT\settings\.ddbmcon.msappagentconfig. Based on this parameter setting, the logs older than the <number_of_days> are deleted.

For example, with the following parameter setting, the operational logs are deleted after 5 days:

purgeOperationalLogDays = 5