03-15-2015 07:41 AM
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,
03-15-2015 08:06 AM
03-15-2015 08:31 AM
9.0.2
03-15-2015 09:57 AM
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
03-15-2015 05:45 PM
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
03-16-2015 06:04 AM
Thanks guys. Appreciated.