SQL Backup - Automated Restore logs
jhutchings
Posts: 3 New member
in SQL Backup
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?
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?
Tagged:
Answers
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
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com
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.
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
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com