SQL Backup - Automated Restore logs

jhutchings

Hello,

Does the automatic restore process only write to the SQLBackupReportingDatabase tables for restore (restorefiles,restorehistory,restorelog) if there is a failure or an issue? I am wanting to build out a report based on the data in those tables for all restore processes (success or fail), but it doesnt seem like it writes to that table unless there is a flag I am missing in my restore job? 

Eddie D

Hi, thank you for your forum post.

Just to confirm you are referring to the reporting database created when generating reports for multiple servers, as per this help article?   If the answer is yes, the reporting database only reports on backup history.  There is no reporting mechanism for the restore process or jobs.

Many Thanks
Eddie

jhutchings

Hi Eddie,

Yes - that database. If that is the case, why are there 3 tables in there that log restore operations when I run one through SQL Backup Pro? See screenshot attached. The SQLBackupReportingDatabase was auto-created by SQL Backup Pro, then I launched a few test restores on the same server, and it appeared to log them but only the errors. Im not wanting to use the native report tool in SQL Backup Pro. I want to write my own queries against it. 

Eddie D

Hi,
Sorry for the delay in replying to this post.

The reporting feature of SQL Backup does not generate reports for the restore jobs that have been performed.  When choosing to generate a report as per this help article, it create data on the backup jobs only

However, as you have spotted, when using the option to generate reports for multiple SQL Instances, the SQLBackupReportingDatabase that needs to be created, does include 3 tables for restore tasks.

I am not sure as to why these 3 tables are created, I suspect that steps were taken in the past to enhance the reporting feature to include the restore jobs but the feature was never actually released and work on adding the feature ceased.  Hence you cannot generate reports via the reporting feature available via the SQL Backup GUI.

So as the tool only appears to add entries for failed restore jobs, not sure that this will help you.

Many Thanks
Eddie