Six ways to restore SharePoint content

http://www.proactivespeaks.com/2013/05/07/sharepoint-2010-six-ways-to-recover-lost-content/

How to force remove site if remove-spsite gives an error 0x80070003

https://peterheibrink.wordpress.com/2014/08/21/forcefully-delete-site-collection/

$siteUrl = “http://dms/case/P68430“
$site = get-spsite $siteUrl
$siteId = $site.Id
$siteDatabase = $site.ContentDatabase
$siteDatabase.ForceDeleteSite($siteId, $false, $false)

How to recover SQL db with corrupted log

http://www.sqlskills.com/blogs/paul/creating-detaching-re-attaching-and-fixing-a-suspect-database/

New-SPContentDatabase creates database with guid instead of name

Hello if you are trying to create a content DB with a name, but instead SP creates name with GUID - make sure that SQL database is deleted from Management studio, but also that files in the disk also deleted (mdf and log). If files will still be there, powershell will not create DB with that name.