Export sites, lists, or document libraries in SharePoint Server
APPLIES TO: 2013 2016 2019 Subscription Edition SharePoint in Microsoft 365
You can export a site, list, or document library in SharePoint Server by using the SharePoint Central Administration website or Microsoft PowerShell. The backup tool that you use depends on the kind of environment that you have deployed, your backup schedule requirements, and service level agreements that you have made with your organization.
Before you begin
We recommend that you regularly back up the complete farm. However, business or IT requirements might require you to export a site, list, or document library. Regularly exporting sites, lists, and document libraries reduces data losses that might occur from hardware failures, power outages, or other problems. It is a simple process and helps make sure that data is available for recovery, if that is required. You can only export one site, list, or document library at a time.
For information about what to back up and which tools to use, see Plan for backup and recovery in SharePoint Server.
Before you begin this operation, review the following information about prerequisites:
Before you begin, you must create a folder on the local computer or the network in which to store the export file. For better performance, we recommend that you export to the local computer and then move the export file to a network folder.
You cannot use SQL Server tools or Data Protection Manager to export a site, list or document library.
Use PowerShell to export a site, list, or document library in SharePoint Server
You can use PowerShell to export a site, list, or document library manually or as part of a script that can be run at scheduled intervals.
To export a site, list or document library by using PowerShell
Verify that you have the following memberships:
securityadmin fixed server role on the SQL Server instance.
db_owner fixed database role on all databases that are to be updated.
Administrators group on the server on which you are running the PowerShell cmdlets.
An administrator can use the Add-SPShellAdmin cmdlet to grant permissions to use SharePoint Server cmdlets.
If you do not have permissions, contact your Setup administrator or SQL Server administrator to request permissions. For additional information about PowerShell permissions, see Add-SPShellAdmin.
Start the SharePoint Management Shell.
At the PowerShell command prompt, type the following command:
Export-SPWeb -Identity <SiteURL> -Path <Path and File Name> [-ItemUrl <URL of Site, List, or Library>] [-IncludeUserSecurity] [-IncludeVersions] [-NoFileCompression] [-GradualDelete] [-Verbose]
<SiteURL> is URL for the site, list, or library that you are exporting.
<Path and FileName> is path and name for the site, list, or library that you are exporting.
<URL of Site, List, or Library> is the URL for the site, list, or library where you are exporting.
If you are exporting a large site, list, or document library, you can use the
GradualDeleteparameter. When this parameter is used, the site collection is marked as deleted, which immediately prevents any further access to its content. The data in the deleted site collection is then deleted gradually over time by a timer job instead of at one time, which reduces its effect on the performance of farm servers and SQL Server.
To specify which version of the site, list, or document library to include, use the
IncludeVersionsparameter and specify "LastMajor" (default), "CurrentVersion", "LastMajorandMinor", or "All". To include the user security settings with the list or document library, use the
IncludeUserSecurityparameter. If you want to overwrite the file that you specified, use the
Forceparameter. To view the progress of the backup operation, use the
NoFileCompressionparameter lets you specify that no file compression is performed during the export process. Using this parameter can lower resource usage up to 30% during the export process. Using this parameter will result in a backup folder being created instead of a compressed file. If you use the
NoFileCompressionparameter in the
Export-SPWebcommand, you must also use it when you import the content by using the
For more information, see Export-SPWeb.
We recommend that you use Microsoft PowerShell when performing command-line administrative tasks. The Stsadm command-line tool has been deprecated, but is included to support compatibility with previous product versions.
Use Central Administration to export a site, list, or document library in SharePoint Server
You can use Central Administration to export a site, list, or document library. You can only export one site, list, or document library at a time.
To export a site, list, or document library by using Central Administration
Verify that the user account that is performing this procedure is a member of the Farm Administrators group.
Start Central Administration.
In Central Administration, on the home page, click Backup and Restore.
On the Backup and Restore page, in the Granular Backup section, click Export a site or list.
On the Site or List Export page, in the Site Collection section, select the site collection from the Site Collection list, and then select the site from the Site list.
If you are exporting a site, skip this step, Select the list or document library from the List list.
In the File Location section, in the Filename box, type the UNC path of the shared folder and the file to which you want to export the list or document library. The file name must use the .cmp extension.
If the file already exists and you want to use this file, select the Overwrite existing files check box. Otherwise, specify a different file name.
If you want to export all the security and permissions settings with the list or library, in the Export Full Security section, select the Export full security check box.
If you want to specify which version of the list or library to export, select one of the following versions from the Export versions list:
Last Major and Last Minor
When you have specified the settings that you want, click Start Export.
You can view the status of all backup jobs at the top of the Granular Backup Job Status page. You can view the status of the current backup job in the Content Export section of the page. The status page updates every 30 seconds automatically. You can manually update the status details by clicking Refresh. Backup and recovery are Timer service jobs. Therefore, it may take several seconds for the backup to start.
If you receive any errors, you can review them in the Failure Message column of the Backup and Restore Job Status page. You can also find more details in the <file name>.export.log file at the UNC path that you specified in step 6.
Plan for backup and recovery in SharePoint Server