cancel
Showing results for 
Search instead for 
Did you mean: 

SQL space required during EV9 toEV10 Upgrade

Fremont
Level 5
Partner Accredited

Has anyone seen any guidelines on how much space is required for sql data and log files during EV9 to EV10 upgrade?

The Upgrade guide mentions space requirement for the directoy DB only, which is usally very small.

What about large vault store DB's and SQL System DB's?

Thanks,

5 REPLIES 5

JesusWept3
Level 6
Partner Accredited Certified
What version of EV9?
https://www.linkedin.com/in/alex-allen-turl-07370146

Fremont
Level 5
Partner Accredited

9.0.2

JesusWept3
Level 6
Partner Accredited Certified

ok so there is a big change going to 9 SP5 and 10 where it updates savesetidentity column in the HoldSaveset table goes from int to bigint, and if you have a lot of savesets on hold can take a bit more space but really hammers the transaction logs and thats on the VaultStore database side

the trans log required was about 50% of the space used by the database

https://www.linkedin.com/in/alex-allen-turl-07370146

AndrewB
Moderator
Moderator
Partner    VIP    Accredited

if you dont have the space then what you might do is take a full backup before the upgrade, change the recovery mode to simple, upgrade, then change back to full

Fremont
Level 5
Partner Accredited

Thanks guys.  Appreciated.