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.
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
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.
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.
Figure : Granular Backup Job Status.
Once the job completed it will show the status as completed.
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.
Figure : Export log file
Good! Half of the job has been completed.
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.
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 https://www.sharepoint-journey.com -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.
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.