Post
Ask Question

Back Up Content Databases In SharePoint 2013

This blog will help you learn how to back up a single content database in SharePoint 2013.We have the following three methods to back up a content database

  • SharePoint Central Administration website

  • Windows PowerShell

  • SQL Server tools.

In this blog we will see about the powershell method to backup the Content Db’s in SharePoint 2013.

Why is backup needed?

Regularly backing up content databases 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 data is available for recovery, if that is required.

The backup tool that you use depends on the kind of environment that you have deployed, what your backup schedule requires, and service level agreements that you have made with your organization.

Steps to backup your content database

Windows PowerShell to back up a content database manually ,

  • Start --> SharePoint 2013 Management Shell.

Copy the below script and execute,

Check that the current user has the following permissions

  • securityadmin and db_owner fixed server role on the SQL Server instance.

Syntax

Source: MSDN

  1. Backup-SPFarm -Directory   <BackupFolder>  -BackupMethod {Full | Differential} -Item <ContentDatabaseName> [-Verbose]  
  2. Example:  
  3. Backup-SPFarm -Directory  D:\Backupfolder -BackupMethod {Full | Differential} -Item SP_Search2013 -Verbose  

Conclusion

Was my blog helpful?

If so, please let us know at the bottom of this page. If not, let us know what was confusing or missing and I’ll use your feedback to double-check the facts, add info, and update this article.