Content Databases available but can't see the Site Collections on SP 2013

Question

Hey Everyone,

We are having issues that Site Collections disappeared on SP 2013. I found out that root deleted somehow. I tried to recover the root with restore-spsite but no luck. What would be my options?
It's a huge environment. Starting from scratch is not an option.

Thank you

Answer 1

Hi @Dee Akil ,

• First use the Get-SPDeletedSite PowerShell command on your server to find the list of deleted sites and make sure they are indeed in the deleted list.
  When a site collection (that is, a SPSite object) is accidentally deleted in SharePoint Server, the deleted site collection is stored in the SPDeletedSite object, not the SPSite object. To restore a deleted site collection, you must use the Restore-SPDeletedSite cmdlet. Make sure you are using the correct command.
  Reference: Restore-SPDeletedSite
• Reset IIS on all servers in the farm.
• Check the ULS log/event log for more information.
• Try running the configuration wizard to fix.
• Try to detach and attach Content DataBases which having that site collection. Execute it a few times and test(detach and reconnect).
• If you go to the Central Administration to see the site collection details are blank, check that the database uses a standard naming convention and check the permissions on the site collection database for missing values.
• If it doesn't work, the last step is to perform a backup and restore. Recreate the site collection in the CA and overwrite it with the backup. If the web application is broken, you need to restore the backup to the new web application.
  Similar Discussion References: Site Collection is missing

  ---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.