SharePoint : Your storage is almost full - one approach
I've been looking for low impact ways to minimize our storage usage across our SharePoint tenant. This post outlines the approach I took and the outcome, and who it might work for. My environment: Only 350GB remaining in Tenancy 8.7 TB used. 265 sharepoint sites in total (teams / communication etc) I decided to focus on sites with more than 100Gb of storage used. In my case this turned up 16 sites. Of these I had to exclude 2 sites. This left 14 sites using 5.194553 TB My goal was to have low/no impact on users while reducing the volume of content in our M365 tenant SharePoint environment. My approach was to do the following: - Get list of all SharePoint site collections, find out Size of each Those larger than 100Gb do the following: - delete all items in recycle bin deleted more than 30 days ago (current setting 93 days, unchanged) - delete all items from 2nd stage recycle bin (current setting 30 days, unchanged) - change all user libraries from 500 to 100 major versions In my environment the recycle bins are rarely used and when I ran a script to work out the average number of versions it was in the 10s at most and for most sites it was 3 or 4. NOTE no sites have minor versioning turned on. I wanted to measure the change so I exported a usage report pre and post doing the above. To achieve all this I used the following code, then the following day checked the SharePoint admin centre reported the same "Storage used" numbers. BE AWARE the code below DELETES data you cannot get back (file versions, and files in the recycle bin). DO NOT RUN THIS to try it out. Test it on one or two sites first. Even if you have backups getting version history back would be very challenging. <# goal is to reduce size sites take up 1 change version from 500 to 100 2 recycle bin deleted more than 30 days ago, move to 2nd stage recycling 3 empty second stage recycling #> #Get current stats #Connect to Admin Center $AdminCenterURL = "https://MyCompanyName-admin.sharepoint.com" Connect-PnPOnline -Url $AdminCenterURL -Interactive reportTenantSiteCollectioninfo function reportTenantSiteCollectioninfo { Try { #export file path $dateStamp = get-date -format "yyyyMMdd-hhmm" $CSVPath = "c:\Temp\SiteUsageRpt-"+$dateStamp+".csv" #Get all site usage details $Sites = Get-PnPTenantSite -Detailed | Select * $SiteUsageData = @() ForEach ($Site in $Sites) { #Collect site data $SiteUsageData += New-Object PSObject -Property ([ordered]@{ 'Title' = $Site.Title 'URL' = $Site.Url 'Description' = $Site.Description 'Owner' = $Site.OwnerName 'Storage Quota' = $Site.StorageQuota 'Storage MaximumLevel' = $Site.StorageMaximumLevel 'Storage Usage Current' = $Site.StorageUsageCurrent 'Resource Quota' = $Site.ResourceQuota 'Resource Quota Warning' = $Site.ResourceQuotaWarningLevel 'Resource Usage Average' = $Site.ResourceUsageAverage 'Resource Usage Current' = $Site.ResourceUsageCurrent 'Template' = $Site.Template 'Sharing Capability' = $Site.SharingCapability 'Lock Status' = $Site.LockState 'Last Modified Date' = $Site.LastContentModifiedDate 'Subsites Count' = $Site.WebsCount }) } $SiteUsageData #Export Site Usage Data to CSV $SiteUsageData | Export-Csv $CSVPath -NoTypeInformation Write-Host "Site Usage Report Generated Successfully!" -ForegroundColor Green } Catch { Write-Host -ForegroundColor Red "Error generating site usage report:" $_.Exception.Message } } Function Set-PnPVersionHistoryLimit { param ( [Parameter(Mandatory=$true)] $Web, [parameter(Mandatory=$false)][int]$VersioningLimit = 100 ) Try { Write-host "Processing Web:"$Web.URL -f Yellow Connect-PnPOnline -Url $Web.URL -Interactive #Array to exclude system libraries $SystemLibraries = @("Form Templates", "Pages", "Preservation Hold Library","Site Assets", "Site Pages", "Images", "Site Collection Documents", "Site Collection Images","Style Library","Teams Wiki Data") $Lists = Get-PnPList -Includes BaseType, Hidden, EnableVersioning #Get All document libraries $DocumentLibraries = $Lists | Where {$_.BaseType -eq "DocumentLibrary" -and $_.Hidden -eq $False -and $_.Title -notin $SystemLibraries} #Set Versioning Limits ForEach($Library in $DocumentLibraries) { #powershell to set limit on version history If($Library.EnableVersioning) { #Set versioning limit Set-PnPList -Identity $Library -MajorVersions $VersioningLimit Write-host -f Green "`tVersion History Settings has been Updated on '$($Library.Title)'" } Else { Write-host -f Yellow "`tVersion History is turned-off at '$($Library.Title)'" } } } Catch { Write-host -f Red "Error:" $_.Exception.Message } } <# Get a list of big sites #> $bigSites = $SiteUsageData | where "Storage Usage Current" -gt 100000 $bigSites = $bigSites | where title -notin ("excluded site 1","excluded site 2") $bigSites.count #loop through the big sites foreach($bigsite in $bigSites) { connect-pnponline -url $bigSite.URL -interactive ## get the deleted items that were deleteed more than 30 days ago $date30daysago = (get-date).adddays(-30) $DeletedItemsOlder = Get-PnPRecycleBinItem | Where { $_.DeletedDate -le $date30daysago} | Sort-Object -Property DeletedDate -Descending $DeletedItemsOlder.count #move all these to 2nd stage recycle bin $DeletedItemsOlder | Move-PnPRecycleBinItem -force #empty the second stage recycle bin Clear-PnPRecycleBinItem -SecondStageOnly -force #get all the libraries $Webs = Get-PnPSubWeb -Recurse -IncludeRootWeb ForEach($Web in $Webs) { Set-PnPVersionHistoryLimit -Web $Web } } #get site info again reportTenantSiteCollectioninfo Outcome [Updated 7 Aug 2023] On the day the outcome was spectacularly unsuccessful. I saved 24GB by doing this across 5.194553 Terra bytes or less than 0.5 % So worth trying, but not valuable in my environment, I thought. But when I looked at the SharePoint admin screen, Storage used, in August there is a big drop two days after running this script. From 8.8TB down to 8.6TB so approx 200GB saving. Unfortunately this may not have been all to do with this script (other things going on in my tenant) but a lot of it is, again not massive at 2% but useful. When would this be valuable for reducing storage volume ? I think the key thing isn't the removal of files from the recycle bins, but the removal of older versions of files. SO if you have an environment with most files having 100's of versions , and those versions are large changes to the file each time. (e.g. a daily report that has new images replace existing ones each day) then this could save a lot of space. What about you? How do you reduce SharePoint storage? What have you found that works?
Access Denied Page blocked as it violates the Acceptable Use Policy
my access to all my files is blocked. No warning or informatiom why. there is very important Personal and medical data stored. m365 administer request didn't help at all. didn3ven understand the problem. . is there a way to get access back to get the important data? after that I don't care If everything is deleted.
Onedrive file sync issue
I just recently had an issue where my files were not synced because i had run out of onedrive storage space so i just got rid of a bunch of unnecessary files sitting around which freed up a ton of space. The files still werent synced so i resett one drive to sync them back up but when i did that it just restored the files i had just deleted. I kept trying over and over again but the same kept happening and now i cant sycn my files. Ive tried everything, restarted my computer. Reinstalled onedrive but its all not working and my files and folders wonf sync. What do i do to fix this?OneDrive wanted me to set up backing up to OneDrive, again
When I logged into my Windows 11 machine here at home, I was presented with a full-window popup from OneDrive. It wanted me to set up backing up my important folders like Documents, Photos, etc. I have been paying for Microsoft 365 Family Edition for at least 10 years, so I've done this already. But I thought I'd go ahead and do it again. But now I'm wondering, might I have accidentally created a second schedule job to back up my Documents, Photos, etc. to OneDrive, duplicating what I've done when I set those things up years ago?
Date taken option removed!
I’m finding One Drive increasingly frustrating as a photographer as the date taken option has been removed and my files are badly muddled, this option was part of the app for years so why did the developer remove it. Very annoying for professional photo work so bring it back.
OneDrive deleted thousands of my files?
I'm hoping somebody here can help me, because I can't find any kind of "Support" link just for OneDrive. Yesterday, for no reason I can determine, OneDrive (personal) deleted a couple thousand old files of mine and put them in the Recycle Bin. I was not using even half of my 1 TB storage, and I did not delete these files myself. They were in various folders. Some had been accessed very recently, some had not been accessed in years. I looked for the files on the app on my phone, on the website, and by trying to find deleted files through apps on my phone (i.e. I looked for a deleted Excel file and it was not found). They were all different file types - Excel, Word, PDF, pictures. I cannot figure out why it did this, and I haven't been able to find any documentation of a known glitch. Has anyone else had this happen?Allow for the expansion of physical disks in a storage pool
Allow for the expansion of physical disks in a storage pool just like lvm on Linux. This would be useful in virtual environments and in Azure to be able to expand the physical representation of the virtual disk file. Be it a vmdk or vhdx. This currently allowable on other modern logical volume managers out there. This should be trivial to modify since the meta data is already there. It could be added to the powershell commandlets to rescan-physicaldisk, which would rebuild the metadata on the pool. I have a feedback hub suggestion open on it, which if you could please upvote: https://aka.ms/AAy4ihwExplore HPC & AI Innovation: Microsoft + AMD at HPC Roundtable 2025
The HPC Roundtable 2025 in Turin brings together industry leaders, engineers, and technologists to explore the future of high-performance computing (HPC) and artificial intelligence (AI) infrastructure. Hosted by DoITNow, the event features Microsoft and AMD as key participants, with sessions highlighting real-world innovations such as Polestar’s adoption of Microsoft Azure HPC for Computer-Aided Engineering (CAE). Attendees will gain insights into cloud-native HPC, hybrid compute environments, and the convergence of simulation and machine learning. The roundtable offers networking opportunities, strategic discussions, and showcases how Microsoft Azure and AMD are accelerating engineering innovation and intelligent workloads in automotive and other industries.
