Forum Discussion

GertjanA's avatar
GertjanA
Moderator
14 years ago
Solved

upgrade to 902, update journalarchive table question

Hello all,

I'm in progress to prepare for upgrading EV80SP4 to EV90SP2
In the upgrade guide I read:
Part: Vault store database modifications
The modifications include a single update to all the rows of the JournalArchive table, and the creation of a clustered index.

I assume this affects the SQL transactionlogfiles?
As it updates all rows, will that not generate enormous logfiles (if you have large db that is?)

Anyone monitored this during an upgrade?

Thanks.

Gertjan

Enterprise Vault
Information Governance
  • JesusWept3's avatar
    JesusWept3
    14 years ago
    No but if you really have that large of a backlog in your JA table then just set to simple logging for the upgrade and then set back to full logging, it's not like the transaction log mid upgrade will be of any use

2 Replies

Sort By
  • JesusWept3's avatar
    JesusWept3
    Level 6
    14 years ago
    No but if you really have that large of a backlog in your JA table then just set to simple logging for the upgrade and then set back to full logging, it's not like the transaction log mid upgrade will be of any use