Since I had someone on another community asking me last week about checking database backups to pull some detailed information, I wanted to highlight a script I wrote 2.5 years ago when I was an SA at Veeam doing automation.
I do not say that to brag about myself or my work, but to raise the point that there is a treasure trove of knowledge and idea that can be pulled from the VeeamHUB PowerShell repository.
These scripts in particular will allow you to filter based on VM name and/or number of hours as a window, but neither is required.
Then for each restore point matching your defined VM name(s) within the specified 'Filter Hours' period, it will launch a restore session for each restore point. Details of the restore points, databases, and database files will be gathered from the restore session, and the arraylist of the results will be output.
If no filter is defined, all of the database restore points will be tested and details will be returned.
Your mileage may vary, but I run through about 240 restore points in a nested virtual environment in my home lab in approximately 10 minutes.
The script for MS SQL can be found here: Run-SQLRestorePointReport.ps1 (GitHub)
The script for Oracle can be found here: Run-OracleRestorePointReport.ps1 (GitHub)
To see both of these in a live-action demo, check them out here:
Hope this helps y’all out. Please feel free to use the code, steal it, critique it, and/or learn from it. :)