Report backup status for specific Database on an MS SQL Cluster

[fbs@jma.dk]

Hi
I am looking for a way to report/show backup status for a specific DB on an MS SQL Cluster.
Facts:
- MS SQL Cluster are backed up by agents and via a protection group
- The SQL cluster contains a large number of databases
- Using Veeam VBR 12.3
- Using VeeamOne
We need to, on a monthly basis, report the backup status for a specific database (a customer request).
I assume there probably will be some manuel tasks involved, which is ok for us.
I am looking for a way to maybe export backup status for each database and then just filter out those that are needed to view.
We have been looking through the available report in VeeamOne and the closest we get is using the "Veeam Enperprise Application Plug-ins" -> "Database Log Protection History"
and drilling down to see the wanted database. But I wish I could export the data in order to filter out those that I need to view.

Hope this gives you an idea on what I am looking for.
Many thanks in advance.

Best regards
Finn Busk

[jorgedlcruz]

Hello Finn,
That is the best report to get details of SQL Cluster at the moment. Other reports like Workload Protection History can help, but perhaps do not include SQL Cluster yet.

In upcoming Veeam ONE v13, you will be able to filter more granularly every single report, so even Database Log Protection History will look really useful, down to the database you need to show, meaning you can really have 1 report per database if you wish, and automate those to be send to the customer in PDF/CSV format.

Let's wait a few weeks until v13 is out, so we can revisit the requirement.

Thank you!