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 cr
a separate application or farm to recover the unused or backup data.
are the steps to recover the content database.
Step 1: Go to Central Administration-> Backup and
Step 2: Select Recover data from an unattached content
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.
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.
Step 4: Enter destination for the file to be
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
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
Now we will import the backup list data into SharePoint site
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
successful completion of the above operation, navigate to the website where the
list data are imported. (Site mentioned in identity parameter).
In this case