Upgrading from Enterprise Vault 2007: Upgrading the auditing database

If you upgrade an Enterprise Vault 2007 system in which you enabled auditing, you must upgrade the Enterprise Vault auditing database schema.

To upgrade the auditing database schema

  1. Make sure that you have backed up the EnterpriseVaultAudit database.

  2. For Microsoft SQL Server 2000, start SQL Query Analyzer. For Microsoft SQL Server 2005 or 2008, start SQL Server Management Studio.

  3. In the left pane of SQL Query Analyzer or SQL Server Management Studio, select the EnterpriseVaultAudit database.

  4. From the File menu, click Open > File.

  5. Navigate to the Enterprise Vault installation folder (typically C:\Program Files\Enterprise Vault) and select the file Audit_Schema_Upgrade.sql.

  6. From the Query menu, click Execute.

    After a short time SQL Query Analyzer or SQL Server Management Studio indicates that the script has completed successfully.

  7. Exit from SQL Query Analyzer or SQL Server Management Studio.