After a lot of searching we found that it's very hard to restore content which deleted from SharePoint designer and we didn't want to restore the all farm as it's time consuming and risky for us.
So we found only one way to do this, by restoring from the content database (fortunately we had a backup from it)
The below steps explain how to restore your SharePoint deleted site from content database, hope it'll be helpful for you.
Method #4: Restore from an Unattached Content Database
SharePoint 2010 provides a really useful feature: If you have a backup of the content database, you can restore it somewhere and browse its contents from inside Central Administration.
Note: This method may not work if the content database was using a different version of SharePoint. It definitely will not work if the content database was using SharePoint prior to SP1, and the current version of SharePoint is on SP1 or later, as SP1 alters the schema of all content databases.
Also note that SharePoint uses the Farm Account to log into the database. If the Farm Account does not have access to the database, this method will not work.
To restore from an unattached content database
(1) In Central Administration, select Backup and Restore.
(2) Under Granular Backup, choose Recover data from an unattached content database.
On the next screen, enter the database server name and database name. Choose the authentication (Windows or SQL – if SQL, enter account name and password), and then select an operation: Browse content, Backup site collection, or Export site or list.
(3) Click Next.
On this screen, you can select the site collection, site, list, and operation (backup or export).
(4) Optionally select a different Site Collection, Site, or List by clicking the drop-down. Choose Backup site collection or Export site or list, and click Next.
In this scenario, we will assume you selected Export.
(5) On the next screen, for filename, provide a UNC path plus a filename with *.cmp extension (this is the typical extension SharePoint uses for exports). Optionally selectOverwrite existing files and/or Export full security. For the Export versions, you can select All Versions, Last Major, Current Version, or Last Major and Last Minor.
(6) Click Start Export to begin the export process.
SharePoint shows export progress on the screen. Periodically click Refresh to force the screen to update. If the export succeeds, a Succeeded message displays across from Previous Job.
In the path provided earlier, you will find two files, the exported data (*.cmp) and a log file, example:
To import this data into SharePoint, use the PowerShell command Import-SPWeb as explained here: http://msdn.microsoft.com/en-us/library/ff607613.aspx. Example:
Import-SPWeb http://intranet.sharepoint.com/somesubsite/anothersite –Path export.cmp –IncludeUserSecurity –UpdateVersions Overwrite
For more information about restoring from an unattached database, see this article:
References: http://www.proactivespeaks.com/2013/05/07/sharepoint-2010-six-ways-to-recover-lost-content/
No comments:
Post a Comment