Setting Site's Maximum Storage Quota to Current Size + 50GB using PowerShell

Hi CLConsulting,

# Import the SharePoint Online PowerShell module
Import-Module Microsoft.Online.SharePoint.PowerShell

# Get the current site URL
$SiteURL = "https://example.sharepoint.com/sites/Marketing"

# Connect to SharePoint Online
Connect-SPOService -Url $SiteURL

# Get the current site collection
$Site = Get-SPOSite -Identity $SiteURL -Detailed

# Get the current site storage size in MB
$CurrentStorage = $Site.StorageQuota

# Calculate the new storage quota in MB
$NewStorage = $CurrentStorage + 50000

# Set the new storage quota
Set-SPOSite -Identity $SiteURL -StorageQuota $NewStorage

# Write a confirmation message
Write-Host "The storage quota for site '$SiteURL' has been set to $NewStorage MB."

To use the script, simply replace the $SiteURL variable with the URL of the SharePoint site whose storage quota you want to increase. Then, run the script in PowerShell.

To increase the storage quota for hundreds of sites, you can use a PowerShell loop. For example, the following script will increase the storage quota for all sites in the current tenant by 50GB:

# Import the SharePoint Online PowerShell module
Import-Module Microsoft.Online.SharePoint.PowerShell

# Get all sites in the current tenant
$Sites = Get-SPOSite -Limit All

# Increase the storage quota for each site
foreach ($Site in $Sites) {
    $CurrentStorage = $Site.StorageQuota
    $NewStorage = $CurrentStorage + 50000
    Set-SPOSite -Identity $Site.URL -StorageQuota $NewStorage
}

# Write a confirmation message
Write-Host "The storage quota for all sites in the current tenant has been increased by 50GB."​