Back up databases to snapshots in SharePoint Server 2013


Applies to: SharePoint Server 2013

Topic Last Modified: 2016-12-16

Summary: Learn how to back up databases to snapshots in SharePoint Server 2013 by using SQL Server Enterprise.

You can only back up databases to snapshots in SharePoint Server 2013 by using SQL Server Enterprise tools.

We recommend that you regularly back up the complete farm. Regularly backing up the farm reduces data losses that might occur from hardware failures, power outages, or other problems. It is a simple process and helps make sure that all the farm data and configurations are available for recovery, if that is required. For more information, see Back up farms in SharePoint 2013. However, IT requirements might require you to backup databases to snapshots. Although you can back up any farm database to a snapshot, you typically back up content databases.

Before you begin this operation, review the following information:

  • You must first create a folder on the database server for your backup files. If you want to store the snapshots at another location, you can move the backup files to a backup folder on the network after the operation is completed.

  • A database snapshot provides a read-only, static view of a source database as it existed at snapshot creation, minus any uncommitted transactions. Uncommitted transactions are rolled back in a newly created database snapshot because the Database Engine runs recovery after the snapshot was created (transactions in the database are not affected). For more information about database snapshots, see Database Snapshots (SQL Server).

Because SharePoint 2013 runs as websites in Internet Information Services (IIS), administrators and users depend on the accessibility features that browsers provide. SharePoint 2013 supports the accessibility features of supported browsers. For more information, see the following resources:

If you want to back up databases to snapshots, you must use SQL Server tools. The databases that are associated with the farm are determined by the service applications and features that you have installed on the farm.

To back up a database to a snapshot by using SQL Server tools
  1. Verify that the user account that is performing this procedure is a member of the SQL Server db_owner fixed database role.

  2. Open SQL Server Management Studio and connect to the database server.

  3. In Object Explorer, expand Databases.

  4. Select the database that you want to back up, and then click New Query.

  5. Copy the following text, and then paste it to the query pane.

    CREATE DATABASE <snapshot name>
    NAME=<logical name of the database file>,
    FILENAME = 'c:\')
    AS SNAPSHOT OF <database name>;