Unsolved
3 Posts
0
1400
DPA Custom Report - Avamar SQL Backup
Hey Folks,
Got a problem I'm wondering if I can get some light shed in on how to do this. I have multiple SQL Servers with multiple databases per SQL server that I need to back up. I however for audit purposes I need to report on the individual database that has been backed up and the size. I have DPA that I can build reports on but I'm difficulty getting what I need I can't get it to drill down far enough to show the database below the instance.
In this situation I would normally run a query to the database to report it's backup however due to restrictions I am unable to do this. The only way I see to do this is to create individual dataset's and policies that are itemized per database and run them one at a time and report that way. In order to do this cooperation would be needed for the DBA to report each time a DB has been created to include in a backup config which is not really optimal either.
So there has got to be a better way to skin this cat. I'm open to options but keep in mind I can only use DPA and Avamar to gain the information I need.
connolly
2 Intern
2 Intern
•
132 Posts
0
July 12th, 2019 08:00
Not sure if you found a solution to this yet, and I don't have an environment where I can research this further - but I found the following info:
Apparently there is a "hidden" parameter under Backup All Jobs that is described as such:
Instance Name - Name of the database instance backed up (hidden field)
If they really mean "database instance", I would expect that parameter to have the database names that were backed up in the SQL backup job. If not, well ...
The only other thing I can think of - you mention that "you" cannot run a query to the database(s); is DPA set up in a manner that it can query the database(s) and find out if they have been backed up? If so, you could just point at the SQL server and databases instead of pointing at the Avamar jobs.
Not a SQL or DPA guru - but I have been known to creatively skin felines on occasion.