Veritas Enterprise Vault™ Reporting
- About this guide
- Introducing Enterprise Vault Reporting
- Overview of implementing Enterprise Vault Reporting
- Installing Enterprise Vault Reporting
- Configuring Enterprise Vault Reporting
- Configuring FSA Reporting
- Preparing for an FSA Reporting proxy server
- Accessing the reports
- Administrator roles that provide access to Enterprise Vault Reporting's reports
- Accessing Enterprise Vault Reporting's reports from SQL Server Reporting Services Report Manager
- Managing FSA Reporting
- Maintaining the FSA Reporting databases
- Troubleshooting Enterprise Vault Reporting
- Appendix A. Report overviews
- The Enterprise Vault Reporting operation reports
- Archived Items Access Trends report
- The FSA Reporting data analysis reports
- The Enterprise Vault Reporting operation reports
About maintaining the FSA Reporting databases
The initial size of an FSA Reporting database is as follows:
Data device | 100 MB |
Transaction log | 80 MB |
Total | 180 MB |
You must trim each FSA Reporting database regularly to keep the database's history tables at a manageable size, while retaining recent and trend-related information. Enterprise Vault provides a batch file for this purpose. The batch file removes data beyond a specified age, but it retains the data for the trend reports.
FSA Reporting also includes an SQL purging job that moves old data from a database's main tables to its history tables. The purging job helps to keep the main tables at a reasonable size, which enables FSA Reporting to generate its reports quickly.
Note:
The purging job only purges the main tables. You must run the trimming batch file regularly to trim the history tables.
The purging job's move operation can take from one minute to a number of hours for a large database with a lot of data to move. Enterprise Vault places the FSA Reporting database into purging job maintenance mode while it performs the SQL move operation. The FSA Reporting web service suspends the upload of data to the database while the database is in purging job maintenance mode, unless a timeout period is exceeded.
By default the FSA Reporting database purging job runs daily at 9.00 P.M. You can change this schedule if required.
You can run the purging job manually, if for some reason the job does not run automatically for some time.