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?


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

| improve this answer | |
  • 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 – Sudhir Kesharwani May 27 '14 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 May 27 '14 at 15:53
  • Thanks Waqas, I re-attached the database and orphan entry was removed. Thanks for your help. – Sudhir Kesharwani May 27 '14 at 18:02

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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