Prepare to back up and restore farms in SharePoint 2013


Applies to: SharePoint Foundation 2013, SharePoint Server 2013

Topic Last Modified: 2016-12-16

Summary: Learn how to prepare to back up and restore your SharePoint 2013 farm.

It is important to make sure that you have backed up and can recover the data that you need if a failure occurs. Consider the information, procedures, and precautions in this article before you back up and restore the environment. This article discusses restrictions and requirements for backup and recovery and how to create a shared folder on the network that can receive backed-up data.

  • Before you back up data, create a shared folder that stores the data. For best performance, create this folder on the database server. If you want to archive the backups to another server, you can copy the whole backup folder to that server after backup is complete. Be sure to copy and move the whole backup folder and not the individual backup folders under this folder.

  • The SQL Server VSS Writer service, which is available with SQL Server 2008 R2 and SQL Server 2012 database software, must be started for the SharePoint 2013 VSS Writer service to work correctly. By default, the SharePoint 2013 VSS Writer service is not automatically started.

  • Make sure that the SharePoint Foundation 2013 Administration service is started on all farm servers before you perform a backup. By default, this service is not started on stand-alone installations.

  • Make sure that the user accounts that you want to perform a backup have access to the shared backup folder.

  • If you use Central Administration to back up, the database server's SQL service account, the Timer service account, and the Central Administration application pool identity account must have Full Control permissions to the backup locations.

  • The database server and farm server that you want to back up must be able to connect to one another.

  • If you use SQL Server with Transparent Data Encryption (TDE), and you use either SharePoint tools or SQL Server tools to back up your environment, the TDE encryption key is not backed up or restored. You must manually back up the key. When you restore the environment, you must manually restore the key before you restore the data. For more information, see Understanding Transparent Data Encryption (TDE).

You can’t back up or restore everything in a SharePoint environment. For more information about backup and recovery architecture and about backup and restore restrictions, see Overview of backup and recovery in SharePoint 2013.

  • You cannot use a backup made from one version to restore to another version.

  • You can use a backup made from one version to upgrade to another version.

  • The update level of the farm to which you restore cannot be lower than the update level of a backup.

    The destination farm must have the same or newer update level. For information about how to upgrade, see Upgrade to SharePoint 2013.

If you perform a backup while a task that creates or deletes databases is running, pending changes might not be included in the backup.

Do not modify the spbackup.xml file. SharePoint 2013 uses this file. A change can make the backups unusable.

Use this procedure to create a shared folder on the network that can receive and hold backedup data. You can also use this shared folder when you restore data. If you already have a shared folder that serves this purpose, you do not have to perform this procedure. By performing the following procedure, you ensure that you can access the shared folder from the computer that runs SQL Server database software and from the computer that hosts the SharePoint Central Administration website.

To create a shared folder
  1. Verify that the user account that is performing this procedure is a member of the Administrators group on the computer on which you want to create the shared folder.

  2. If you create the shared folder on a computer other than the one running SQL Server, make sure that the service account for SQL Server (MSSQLSERVER) is using a domain user account and that it has Full Control permissions on the shared folder.

  3. On the server on which you want to store the backup data, create a folder.

  4. On the Sharing tab of the Properties dialog box, click Advanced Sharing, and then click Permissions, add the following accounts and assign them Full Control of the shared folder:

    • SQL Server service account (MSSQLSERVER)

    • The SharePoint Central Administration application pool identity account

    • The SharePoint 2013 Timer service account (if you are using SharePoint Server 2013 to perform backups).

For more information, see Shared Folders