Remove and recreate all personal sites - mysites - remove them from DB without waiting ~25 days

Question

Is there a easy way to remove (delete) all personal sites and recreate them all over again? I also want to delete them from the sql.

I've tried to delete personal sites and run my site clean up job but it seems not to be removed from the DB. I know I have to wait ~14 days and then ~11 days before they get removed from the DB. Is there a way to force delete them without waiting?

The reason I want to delte the db entry is to not get in a situation that the db runs out of space.

The best way would be to recreate the entire web application but I can't do that because of integration to all other systems.

When deleting personal mysites I run this lines..

..
foreach($profile in $AllProfiles)
{
    $DisplayName = $profile.DisplayName
    $AccountName = $profile[[Microsoft.Office.Server.UserProfiles.PropertyConstants]::AccountName].Value  

    if($profile.PersonalSite -ne $Null)
    {
       $profile.PersonalSite.Delete()
       write-host $AccountName , " personel site deleted successfully" -ForegroundColor Green
    }
}

Answer 1

Can you try with the below PS code for deleting the mysites?

 Add-PSSnapin "Microsoft.SharePoint.PowerShell"

 [Reflection.Assembly]::LoadWithPartialName("Microsoft.Office.Server")
 $mysiteHostUrl = "http://my"
 $mysite = Get-SPSite $mysiteHostUrl
 $context = [Microsoft.Office.Server.ServerContext]::GetContext($mysite)
 $upm =  New-Object    
 Microsoft.Office.Server.UserProfiles.UserProfileManager($context)
 $AllProfiles = $upm.GetEnumerator()
 foreach($profile in $AllProfiles)
 {
 $DisplayName = $profile.DisplayName
  $AccountName = 
      $profile[[Microsoft.Office.Server.UserProfiles.
        PropertyConstants]::AccountName].Value  
  if($profile.PersonalSite -ne $Null)
   {
   $profile.PersonalSite.Delete()
   write-host $AccountName , " personal site deleted successfully"
    }
  }
  $mysite.Dispose();