upgrade to 902, update journalarchive table question

[GertjanA]

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

[JesusWept3 · Accepted solution]

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

[GertjanA]

Hello JW,

No backlog (as far as I know), just curious.