Search for SQL Backups

[mesiah70]

Dear all,

I would like to know, if there is a chance to search the Veeam Backup LOGS against SQL Backup. I'm trying to figure out which servers are being backed up of sql Databases.
My issues is, that I have tons of servers which is not handy check them one by one. How can I achieve this via PS eventually?

Many Thanks

Haydar

[HannesK]

Hello,
and welcome to the forums.

I don't have a good idea for powershell... but did you see, that if you use the restore button in the main ribbon -> vmware -> restore from backup -> application items restore -> SQL -> it only shows the VMs with SQL backups?

Maybe that's "good enough"?

Best regards,
Hannes

[oleg.feoktistov]

Hi Haydar,

You can get all the servers hosting SQL, which were backed up with application-aware processing with the cmdlet below:

Code: Select all

Get-VBRApplicationRestorePoint -SQL

You can then compose a simple report on which servers hosting SQLs were backed up with AAIP:

Code: Select all

# Get SQL restore points (backed up with AAIP)
$SQLs = Get-VBRApplicationRestorePoint -SQL

# Get all restore points
$RPs = Get-VBRRestorePoint

# Empty array. Contains a final report when the script is executed.
$totalBackedUp = @()

# Query each restore point from 2 arrays above and compare ids
foreach ($rp in $RPs) {
    foreach ($sql in $sqls) {
        if ($sql.Id -eq $rp.Id) {

# Add IsSQL = true if the server hosts SQL and is backed up with AAIP
            $totalBackedUp += $rp | select Id, Name, @{n='IsSQL';e={$true}}
        }

# Add IsSQL = false if it is any other server
        else {
            $totalBackedUp += $rp | select Id, Name, @{n='IsSQL';e={$false}}
        }
    }
} 

Thanks,
Oleg

[jhoughes]

I actually covered this with a reporting script which will start sessions with the Explorer to investigate each.

It's up on VeeamHub here:
https://github.com/VeeamHub/powershell/ ... aseReports