We were moving some sites onto new database, one of the site restoration interrupted and resulted in having one orphan entry in the database.

We are not able to restore the site backup with the same link, do we have any option of removing orphan site collection from SharePoint 2013 database?

1 Answer 1


there are couple of options you can try to remove the orphan in the databases. Did you try to run the restore with force parameter?

  1. Detach the content DB wait for couple of min and re attach it
  2. try to repair the Content DB
  3. if you have site id (returning while running get-spsite) then you can forcefully delete it from SharePoint via powershell or stsadm
  4. you can also try to remove it from database using the powershell.
  5. if none working then you have to move all site collection from corrupted DB to new, Once moved then delete the orphan DB.

i already write down the steps here Link# 1 Link# 2

  • Waqas, thanks for this, I am able to see the site entry when i do a Get-SPSite -ContentDatabase command, the site is also visible in the Site Map table of config database. I am hopping that re-attaching the db will not have same impact Commented May 27, 2014 at 15:52
  • 1
    then i believe, your best bet is run the stsadm to forcefully delete it...stsadm -o deletesite -force -siteid e2a114b8-80c9-41f6-87bf-3feddf2ad9b6 -databaseserver DS1 -databasename DB1
    – Waqas Sarwar MVP
    Commented May 27, 2014 at 15:53
  • Thanks Waqas, I re-attached the database and orphan entry was removed. Thanks for your help. Commented May 27, 2014 at 18:02

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.