.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Melody Anderson
Eminent IT

Home >> Articles >> SharePoint >> Post New Resource Bookmark and Share   

 Subscribe to Articles

Recover Data from an Unattached Content Database in SharePoint 2010

Posted By:Sunil Yadav       Posted Date: September 21, 2010    Points: 25    Category: SharePoint    URL: http://www.dotnetspark.com  

This article explains how we can recover data from an unattached content database in SharePoint 2010.

Again this is the new feature enhancement in SharePoint 2010. Now the SharePoint administrators will be able to recover site collection, sub sites and lists using out of box feature in SharePoint 2010. The SharePoint administrator can connect to any Sql server instance containing content database. This provides an administrator the ability to browse the contents like sites, sub sites and lists and choose the data they want to export, eliminating the need of creating a separate application or farm to recover the unused or backup data.

Below are the steps to recover the content database.

Step 1: Go to Central Administration-> Backup and Restore

Step 2:  Select Recover data from an unattached content database

On selecting it will take you to the Unattached Content Database Data Recovery page which is requires some of the properties shown in the below figure to connect to the Content database.

Step 3: Select content to backup.

 Select site collection and then select a site that belongs to that site collection, and finally the option to choose a specific list under that site. For this demo select List content to backup.

Select list Documents.

Step 4: Enter destination for the file to be exported.

Once done with above it takes to the Granular Backup Job Status page which is use to view the status of export operation. On successful export, the job status become Succeeded.

Files exported are stored in the specified location. Here the file extension is .cmp (Content Migration Package) which is compressed version of .cab file. The .cmp file aggregates the data for export from the source site along with the structure and dependency data. It stores these data as compressed and in a serialized XML files.

Step 5: Import list data using SharePoint 2010 Management PowerShell.

Now we will import the backup list data into SharePoint site using PowerShell.
Open PowerShell Management console and type the following command shown below.
PS C:\Users\sunil> Import-SPWeb -identity http://mossportal -path C:\backup\documents.cmp

On successful completion of the above operation, navigate to the website where the list data are imported. (Site mentioned in identity parameter).

In this case http://mossportal

Happy SharePointing!!!

 Subscribe to Articles


Further Readings:


No response found. Be the first to respond this post

Post Comment

You must Sign In To post reply
Find More Articles on C#, ASP.Net, Vb.Net, SQL Server and more Here

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend