How to delete site collections from the content database

To delete all site collections in a content database you can run the below powershell.

Get-SPSite -Limit All -ContentDatabase WSS_Content | Remove-SPSite -Confirm:$false

Or you can go the central admin and delete site collection one by one

Get the url of sites from the database

Remove each of site using

Hi Bhushana,

Try the below powershell command

Add-PSSnapin Microsoft.SharePoint.PowerShell

$siteUrl = ““

$site = get-spsite $siteUrl

$siteId = $site.Id

$siteDatabase = $site.ContentDatabase

$siteDatabase.ForceDeleteSite($siteId, $false, $false)

This will delete the Sitecollection from the CDB.