Forum Discussion

sandrine_goetha's avatar
sandrine_goetha
Level 6
13 years ago

JournalArchive table question

While reading the requirement to upgrade my system from EV9.0.2 to EV 9.0.3 I read that the size of the JournalArchive table will plays a role in the time to upgrade. I checked all my tables and no...
Best Practice
Enterprise Vault
Information Governance
Tip-How to
  • Percy_Vere's avatar
    Percy_Vere
    13 years ago

    Sandrine, the JournalArchive table retains archive job history for the number of days set in your site properties on the archive settings tab. It's called transaction history.

    You don't want to empty them just ensure you have a backup of the databases pre upgrade.

JesusWept3's avatar
JesusWept3
Level 6
13 years ago

one other thing you should check as well is make sure the compatibility mode of your vault store databases isnt set to SQL Server 2000 (80) otherwise the JA table will grow and grow and grow and never clear out

Otherwise as Percy mentioned, the items will hang around for as long as the transaction history is set for on the site properties which by default is 32 days i think, which is used to help with Vault Cache