List of SAP HANA Log Backups

[Talom]

I recently found out, that the information about SAP Hana Jobs do not have a lot of details anymore.
I am reporting all SAP HANA backups and before Veeam 11 i could differ between full backups and log backups by checking the detaill. If the backup files were named "log_backup_*" i could determine the backup session was a log job.
Now i only get backup files which couldn't be processed. Is it possible to identify a logbackup session somehow? Usually i use everything i get from a cbackupsession object

[PetrM]

Hello,

Please let me find out how to get the requested information using our PS module. By the way, in the version 12, we'll have SAP HANA backup policies for data files and redo log backups with enhanced statistics and monitoring for both session types. Also, why you don't use SAP HANA backup catalog views as a source of data? I guess it would be a more accurate approach than recognizing sessions depending on backup file name.

Thanks!

[Talom]

i am reporting all backup jobs. HANA jobs are just a subset.

I do not have access to the SAP HANA directly so i don't think it's possible to use the backup catalog.

[PetrM]

Hello,

You may try the following script:

Code: Select all

$jobs = Get-VBRPluginJob
foreach ($job in $jobs) {
    $sessions = [Veeam.Backup.Core.CBackupSession]::GetAllSessionsByPolicyJob($Job.Id) | Sort-Object -Property CreationTime
    $session = $sessions[-1]
    $task = Get-VBRTaskSession -Session $session
    $text = $task.logger.GetLog().updatedrecords.Title
    if ($text -like "*log_backup*" ) {
        Write-Host "$($job.Name), $($task.Status) - Log Backup"
    }else{
        Write-Host "$($job.Name), $($task.Status) - Data backup"
    }
}

But please keep in mind that such a script is not supported officially because it calls the internal methods (f.e. GetAllSessionsByPolicyJob, GetLog) of some objects and our support team will be unable to help with technical issues that may happen due to script execution. On the other hand, I wouldn't expect any issues with this script.

Thanks!

[Talom]

Hello,

this topic was on hold from my side until Veeam 12 was released. Now i checked the logger records again and there are still no indicators for log backups.

What PetrM suggested was actually similar to my approach but it only works, if the backup has errors and the failed backup files are listed.
If there is no switch or config option to enable the listing of successful backup files as well, i think i have to search for the largest backup per day to identify a full backup.

[PetrM]

Hello,

By the way, starting from the version 12 you can use SAP HANA backup policy that provides enhanced reporting including the detailed log backup statistics.

Thanks!