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!!!
Comments