Restore content from Backed Up DBs -SharePoint 2013 - Part 2

In Previous part of this , we learnt , how can we restored the old content DB and make it available for export from the UI of CA.

In this part, we will see  , how can we restore the content by exporting the old data and importing it back to the content in context.

Access the old content and export

As the data from older date is restored on the SQL server,this can be accessed from Central Admin. Ensure that the account which is opening the CA, must have access on Restored DB. Following steps can be followed.

• Open CA.
• Navigate to Back and restore page and click on “Recover data from an unattached content database” from the Granular Backup section.
• On this page, filling the information of SQL server and Database name of restored Database.If you have restore the database on different SQL server, please enter the appropriate SQL server name and ensure the operating account has access to the Database.

And click “Next”. Select the appropriate site and the list/library or site which needs to be exported

and further click Next

Click on Start Export on this page.

The export will be completed based on the size of the list,library or site.

Check the shared location and you must see a cmp extension file along with export log.

 

Import the Exported content to Current Site/new
Site

 

Now we need to import the exported data/content to the desired location. The imports just copies the data back on any site as it was exported.

The initially the list had 4 item for this demo and two of them were corrupted and had to be deleted. Now the aim is to retrieve back the data when it had all 4 images working fine.below can be predicted as current view for the list before restore with 2 items.

Following import script should be used.   
  Import-SPWeb -Identity <web application URL> -Path <Location of exported file> -IncludeUserSecurity  
 

More information about Import-SPWeb can be found at https://technet.microsoft.com/en-us/library/ff607613.aspx