DEV Community

Serguey Shinder
Serguey Shinder

Posted on

Our SharePoint Storage Ran Out and a Third of It Was Old Versions of the Same Spreadsheets

In March we finished moving our file shares into SharePoint. Microsoft gives each organisation a pool of one terabyte plus ten gigabytes for each eligible licence, which for our fourteen hundred staff came to about fifteen terabytes. We moved a little under nine, and expected the rest to last us for years.

In October we received a warning that we had nearly used it all. Nobody had moved anything large. The space had gone not to files but to the history of files.

SharePoint keeps previous versions of every document so that people can go back to an earlier copy, and by default a new library keeps up to five hundred of them. Every version counts against the storage pool. That is sensible for a contract that changes twice a year. It is something else for the stock planning workbook our buyers share, which is about ninety megabytes and is open all day, every day, with AutoSave on and a dozen people editing it. Each saved state became a version, and that single workbook was holding around forty gigabytes of its own past. Across the whole estate, versions accounted for more than a third of everything we stored.

On the old file servers this could not have happened, because they kept no history beyond the nightly backup. We had moved our files to a platform with a feature we did not have before, and never decided how much of it we wanted.

Extra storage is sold per gigabyte per month, so buying it would have meant a cost that grew with our editing. We set limits instead. Microsoft added version history limits in 2024, at organisation and library level, either by number of versions or by age. Most libraries now keep a hundred versions, and versions older than six months are deleted. Finance, legal and HR libraries, which have their own retention rules, are excluded and governed by those. We ran the trimming job Microsoft provides against the existing libraries, which gave back about four terabytes over a weekend.

The lesson for me was about defaults. Storage gets planned by looking at what we have. Its history grows from how we work, and nobody had asked how long we wanted to keep it.

– Serguey Shinder

Top comments (0)