Report Backup SAP HANA Plug-In

[GianlucaCroci]

Hello,

We've just installed the SAP HANA Plug-In on a Linux server, and we'd like to receive a Report after the Backup or even once a day (for example in the morning).

this is the only thing I was able to do




We don't yet know how and when the backup will be performed, so I'd like to cover the last 24 H in the report.

Thanks in advance

[oleg.feoktistov]

Hi Gianluca,

Can you, please, clarify if your goal is to obtain the list of SAP HANA plugin backups made for the last 24 hours or it's about sessions?

Thanks,
Oleg

[GianlucaCroci]

Hello Oleg,

yes, I think the best solution is to obtain a 24 H report, where I've all the backup done on the servers that use this plug-in.
Now we've just one environment, but soon we'll have the Test and the Prod too.

thanks

[oleg.feoktistov]

Hi Gianluca,

Please have a look at the example. Is it what you are looking for?

Code: Select all

$date = (Get-Date).AddDays(-1)
$backup = Get-VBRBackup -Name 'Backup Job'
Get-VBRRestorePoint -Backup $backup | where {$_.CreationTime -gt $date}

Thanks,
Oleg

[GianlucaCroci]

Hello Oleg,

thanks a lot.

I've an error

Get-VBRRestorePoint : Cannot get restore points from backup svhanad001 SAP backint backup (ME4084_CED1_B_SAPHANA), because it is encrypted or created by an enterprise application plug-in.
At line:3 char:1
+ Get-VBRRestorePoint -Backup $backup | where {$_.CreationTime -gt $dat ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidData: (:) [Get-VBRRestorePoint], Exception
+ FullyQualifiedErrorId : GetRestorePointErrorId,Veeam.Backup.PowerShell.Cmdlets.GetVBRRestorePoint

Thanks again

[oleg.feoktistov]

Hello Gianluca,

Looks like there is no way to get the list of restore points for SAP HANA plugin backup with official cmdlets as there are no actions we could do with them further. The workaround would be to use unsupported method if it is just for reporting purposes:

Code: Select all

$date = (Get-Date).AddDays(-1)
$oibs = $backup.GetOibs()
$oibs | where {$_.CreationTime -gt $date} | sort -Property CreationTime

Hope it helps,
Oleg

[GianlucaCroci]

Hello Oleg,

thanks a lot.

now I've a list.
I'm trying to see if I can have more info about each row/backup.

Thanks again
have a good day.
Kind regards