Case #08005411

[JDF]

HI
Have an urgent need to supply evidence that all child SQL log jobs are running every 15 mins as required.
You need to evidence the interval/frequency of Agent SQL Server Transaction Log Backup jobs.
I have tried PowerShell and the API, but historical sessions are not exposed.
I’d either like a suitable ps script or a SQL query for your PostgreSQL Veeam B&R database to show job name, start time, and interval between runs for “Transaction Log Backup” jobs.
Many thanks
Jason

[david.domask]

Hi Jason,

Regrettably there's not a supported means of doing this, so you will need to rely on unsupported methods.

Code: Select all

$job = Get-VBRJob -Name "name of Veeam Agent for Windows Job" #[0]
$sqlJob = $job.FindChildJobs().FindChildSqlLogBackupJob()
[Veeam.Backup.Core.CbackupSession]::GetByJob($sqlJob.id) | Sort -Property CreationTime -Descending

Second and Third lines are unsupported methods, but should give you all the sessions for each Agent job. If you have multiple machines performing transaction log backups within a single Veeam Agent for Windows / Linux job, you will have multiple entries in $sqlJob (one for each machine) and you will need to loop over $sqlJob to build your report for all machines in the job.

Similarly, I see Veeam Support recommended the Veeam One Report Database Log Protection History -- while I understand there was some concern about proving it made the exact interval, the RPO monitor should help here to show that it's making / missing intervals and how often it is running.