Reporting in multiple DB
carmelcw
Posts: 14
Hi all,
Did any one used the Reporting for multiple DB? I have follow the help guide and created the "SQLBackupReportingDatabase" on one of my SQL server. I'm able to upload the backup and restore log to this DB.
I would like to know, is there any sql script, store_proc or task I can use to automatic upload the backup and restore log to this DB, so that I don't need to manually run this function?
Since the multiple db report format did not fit my requirement, so I would like to create my own report by directly read this DB. The key point is this DB data should always be up-to-date, so the report will be accurate. Anyone have this kind of working?
Thanks and regards,
Carmel Lee
Did any one used the Reporting for multiple DB? I have follow the help guide and created the "SQLBackupReportingDatabase" on one of my SQL server. I'm able to upload the backup and restore log to this DB.
I would like to know, is there any sql script, store_proc or task I can use to automatic upload the backup and restore log to this DB, so that I don't need to manually run this function?
Since the multiple db report format did not fit my requirement, so I would like to create my own report by directly read this DB. The key point is this DB data should always be up-to-date, so the report will be accurate. Anyone have this kind of working?
Thanks and regards,
Carmel Lee
