Backup and Restore in SharePoint 2013

In this post we will work on how to perform backup and restore activity in SharePoint 2013. Which is common activity every now and then SharePoint administrator use to perform in his day to day life.

In this series of posts you will learn how to perform backup and restore activities in SharePoint 2013 for site data backup using central admin and powershell to have a complete disaster recovery in place.

In part 1 of this series I will cover Export and Import of List in SharePoint 2013 using Central administration and Powershell scripts.

Lists Export and Import:

List Export using Central administration:

I am using central administration screen to export SharePoint list.

From Backup and Restore section of the central admin screen, Click on Export a site or List under Granular Backup. Refer Figure : Export List

Export List

Figure : Export List

Once you click on "Export a site or List" Figure : List Export will appear. Select the appropriate list by selecting the site collection and site. Here I am selecting the customer list.

Please enter file name to which we want to export the list details, advisable extension is cmp, please see the example in the Figure : Start Export.

Once you select the list and enter the file name please click on startexport. Make sure the file path folder you entered has full permissions to the account you logged in to the server.

List Export

Figure : List Export

You can see below Figure : Granular Backup Job Status details. Once you run the job you can delete it as well. See the option to delete Export job. You can observe here that you have all the current job status which includes site collection details, log files, backup path and more importantly the powershell command to restore the data.

Granular Backup Job Status

Figure : Granular Backup Job Status.

Once the job completed it will show the status as completed.

Granular Backup Job Status

It will generate two files "Customers.cmp" and "Customers.cmp.export.log" because I am exporting the details of Customers list.

You can open the export log file "Customers.cmp.export.log" top see how the backup has been processed whether it is successful or there are any errors in that etc. Figure: Export log file.

Export log file

Figure : Export log file

Good! Half of the job has been completed.

Import List: using Powershell:

You can perform import list operations using powershell command "Import-SPweb".

Open SharePoint 2013 management shell type the below command in the "Figure : Powershell Help" to get the help about "Import-SPWeb" powershell command.

Powershell Help

Figure:Powershell Help.

Go to C:\ drive and open the importlist.txt file, it will open the syntax to perform the action. According to that execute the command.

# Importing customer list details

Import-SPWeb -path c:\backup\Customers.cmp -updateversions overwrite

once you run the above command the customer list will get imported into site

you can log file for this Import functionality at "c:\backup" folder as "Customers.cmp.import.log" where you can check if there are any errors related to list import functionality.



In this part1 we have seen how to Export and Import the list details from the central administration page and powershell scripts. In Part2 I will discuss about how to Export and Import the details of the site.

Hope you have enjoyed the part 1 of this backup and restore in SharePoint 2013 series.

You can check part 2 to perform backup and restore of site and site collection activities in SharePoint.

› Export and Import the list

› Export and Import the list

Join 8,000 subscribers and receive instant access to

Devendra's Library of Resources for SharePoint Developers

About Author

Devendra Velegandla is a five-time recipient of Microsoft's Most Valuable Professional (MVP) award (2014-2019) for Office Apps and Services, Office Servers and Services MVP and  SharePoint Server. He received the MCC award for his contributions in Microsoft MSDN/TechNet forums. He loves sharing articles, videos, and tutorial on SharePoint and Office 365.