Veritas Backup Reporter and SQL
I've got a few SQL related questions about Veritas Backup Reporter if anyone can help me! First question: Is it possible to setup VBR to utilise a Microsoft SQL database server instead of the ianywhere database? Second Question: We are after an SQL query to determine the day of the month with the biggest amount of volume, then show which Netbackup Clients and policies, etc that contributed towards the biggest amount of volume used. Has anyone written a query for this currently or know of a way to automate this using the current reporting scripts? We are currently using Version: 6.6.2 (Build 20091213)
VBR Sybase Multi Thread question
Hi All, I installed VBR 6.6 on a Sun T2000 Server with one 8 cores and 32 threads processor. After installing VBR I found out that everytime I run any report, the DBSRV10 daemon uses only one thread and all other 31 threads are idle. This makes the report generation too slow although CPU utilization is less than 5%. Is this a Sybase limitation? Is there anyway to change this and make Sybase/VBR work multithreaded? Cheers, Nicholas
Recovery Job report
Hi, I would like to produce a report detailing Restore jobs and the related backup job to determine how excessive the retention period of backup images is. The Custom report i currently have is returning rows for some, but not all recovery jobs. I believe this is related to the table "backupJobImage" not having entries for all of the restore jobs. Has anybody else looked into this type of report previously ? Adam.
