I have completed few upgrades during last year from SharePoint 2003 to MOSS 2007 and those who know SharePoint will always agree on doing upgrade using Gradual Upgrade as primary choice as it is the most safe method for executing upgrade but on the other side this method consumes lots of Disk Space on SQL Server when the upgrade is running. There is no proper documentation which guides us on this. I am stating even though there is documentation on technet itself about this that this requires about 2 to 2.5 times of the size you are upgrading but never ever in my up gradation projects I was ever near to this thing I had found SQL server using much more space then mentioned on Technet. I have always found about 6-7 times of Space being utilized by SQL Server while upgrade is running and once upgrade is done completely then the temp db gets deleted automatically so space gets freed up but one needs to have provision for the space when you start upgrade.
Hope this helps...
Hiran Salvi
3 comments:
Hi Hiran,
I just want to mention that in the MS boot camp for planning migrations the magic number for calculating disk a space on the SQL server mentioned is 4x if I remember well. Taking in account your experience I would certainly say that 6+ would be safe guess.
Z
Hi Hiran,
I just want to mention that in the MS boot camp for planning migrations the magic number for calculating disk a space on the SQL server mentioned is 4x if I remember well. Taking in account your experience I would certainly say that 6+ would be safe guess.
Z
Hi Hiran,
I just want to mention that in the MS boot camp for planning migrations the magic number for calculating disk a space on the SQL server mentioned is 4x if I remember well. Taking in account your experience I would certainly say that 6+ would be safe guess.
Post a Comment