We have verified audit log also not enabled so we can not know who deleted it. I have verified it is not there in either of the recyle bin is there any to find out who deleted it? & if no PowerShell commad , do we need to restore using Db backup only? pLease confirm in case if it is Db back up method, how we can restore the sub site to same site collection as it allows only 1 record of site collection when we mount the Db to same or different web application It is SharePoint 2016

1.Go to site contents -> Recycle Bin -> Check whether the sub site exists here. Go to site collection -> Site settings -> Recycle Bin -> Check whether the sub site exists here. If sub site does not exist in both recycle bins, there is no PowerShell to restore it. 2.You could backup a sub site through recover data from an unattached content database. Go to Central Administration -> Backup and Restore -> Recover data from an unattached content database -> Export site or list. Then restore the sub site to the site collection. References: https://petri.com/restore-from-unattached-content-database-sharepoint-2013/ https://blogs.msmvps.com/haarongonzalez/recover-data-from-an-unattached-content-database/ Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link. 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.

PowerShell command to restore deleted sub site

Accepted answer

Emily Du-MSFT 41,771 Reputation points Microsoft Vendor

2023-03-15T09:58:55.3333333+00:00

1.Go to site contents -> Recycle Bin -> Check whether the sub site exists here.

Go to site collection -> Site settings -> Recycle Bin -> Check whether the sub site exists here.

If sub site does not exist in both recycle bins, there is no PowerShell to restore it.

2.You could backup a sub site through recover data from an unattached content database. Go to Central Administration -> Backup and Restore -> Recover data from an unattached content database -> Export site or list. Then restore the sub site to the site collection.

References:

https://petri.com/restore-from-unattached-content-database-sharepoint-2013/

https://blogs.msmvps.com/haarongonzalez/recover-data-from-an-unattached-content-database/

Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link.

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.
Please sign in to rate this answer.
sns 9,226 Reputation points

2023-03-16T18:05:07.69+00:00

Hi Emily Du,

Thank you for the response.

I was trying to restore sub site which was giving 403 , using Recover data from an unattached content database method.

Although successfully export is finished , the respective backup file is not visible in the respective path, I tried from CA server and other server multiple times but still the same behavior. Please see below screenshot.

and second approach that mount restored db to different web application, but although I have mounted to different web applicaiton it is giving below error

Please suggest why above 2 are failing and what are the fixes for above 2 methods.

Thank you for your support.

Emily Du-MSFT 41,771 Reputation points Microsoft Vendor

2023-03-17T09:30:02.6833333+00:00

Please verify that the user account that is performing this procedure is a member of the Farm Administrators group and is a member of the db_owner fixed database role.

sns 9,226 Reputation points

2023-03-17T10:27:14.3366667+00:00

Hi Emily Du,

After I got CMP file, While restoring to subsite giving following error. Please suggest further.

& when I used other method which is mounting to different web app with new ID by providing SQL server name, giving following error. Please suggest.

Emily Du-MSFT 41,771 Reputation points Microsoft Vendor

2023-03-21T07:43:02.25+00:00

Whether you create a new sub site before running PowerShell?

sns 9,226 Reputation points

2023-03-21T07:48:59.9833333+00:00

Hi Emily Du,

No.

I was using recover unattach database content method. I saw sub site over there.

and I could get CMP file of that sub site. but when I execute import command it is not working

Emily Du-MSFT 41,771 Reputation points Microsoft Vendor

2023-03-23T07:57:23.2466667+00:00

Before you run PowerShell, please create a sub site first.

sns 9,226 Reputation points

2023-03-26T15:09:49.64+00:00

Hi Emily Du,

Okay, I will create new sub site and check. and will update you.

Emily Du-MSFT 41,771 Reputation points Microsoft Vendor

2023-03-28T01:26:42.7533333+00:00

I am looking forward to your feedback if there is any update.

Please remember to update this thread if you have any progress.

Thank you for your understanding.

sns 9,226 Reputation points

2023-03-28T10:44:35.53+00:00

Hi Emily Du,

It worked after creating a new sub site

Emily Du-MSFT 41,771 Reputation points Microsoft Vendor

2023-03-29T05:47:31.69+00:00

If you find any answers helpful to you, please remember to accept them.

It will help others who meet the similar question in this forum.

Thank you for your understanding.

sns 9,226 Reputation points

2023-04-07T07:24:02.2866667+00:00

Hi Emily DU, I need quick help on this, I faced similar issue for other site collection where I am trying to take list backup from central admin but it is failing with below message , showing success but no file is showing in the path I asked DB team to provide DB creator , security admin and owner role for respective db, but they are asking business justification. Can you provide respective MS link for this. THank you Looking forword to hear from you.

Emily Du-MSFT 41,771 Reputation points Microsoft Vendor

2023-04-07T10:38:12.0066667+00:00

Reference: https://learn.microsoft.com/en-us/sharepoint/administration/restore-content-from-an-unattached-content-database
Sign in to comment

PowerShell command to restore deleted sub site

0 additional answers