Backup and Restore content database SharePoint 2013

Backup and Restore Content DB in SharePoint 2016

This SharePoint 2013 tutorial explains on backup and restore content database SharePoint 2013. What are different approaches for backup and restore in SharePoint 2013? How we can backup and restore content database SharePoint 2013 from SharePoint 2013 central administration.


Backup and Restore content database SharePoint 2013 is a very important concept every SharePoint administrator should know in SharePoint technology.

In SharePoint 2013, we can perform this backup restore in 3 ways:

  • SharePoint Central Administrator
  • PowerShell scripts
  • SQL Server Management Studio

Here we will discuss how we can take Backup and Restore content database SharePoint 2013 from SharePoint 2013 Central Administration approach.

Our objective is to back up and restore the web application on the same FARM. You might be wondering why should we do the backup and restore on the same FARM??? Think about this scenario when we are configuring any application services/change of authentication on a web application and if the behavior is adverse than expected we should be able to restore the old environment.

Backup content database SharePoint 2013

The first step is to take the back of the desired web application.

Step-1:

  • Log on to SharePoint 2013 central administration with a FARM administrator account
  • Click on “Backup and Restore” option as shown in the screenshot
  • Select “Perform a backup” option from “Farm Backup and Restore” zone.
backup content database sharepoint 2013
Backup content database SharePoint 2013

Step-2:
Select the required web application to be backed up and click on the Next button.

backup and restore content database sharepoint 2013
backup and restore content database sharepoint 2013

Step-3:

  • Ensure that backup web application is selected as the desired
  • Select Full / Differential as per the need
  • Provide the backup to create the backup files

Note: This path must be a universal notation like \\servername\foldername

  • Click on “Start Backup
sharepoint 2013 content database backup restore
SharePoint 2013 content database backup restore

Step-4:

  • SharePoint shows who requested this backup
  • It shows the name of the web application the content DB is currently associated with
  • Back directory path which we provided as part of step-2
  • All the custom & Generic solutions deployed in the source web application
  • Since we have initiated the backup job it is showing as A backup or restore is in currently in progress
backup and restore content database sharepoint 2013 using powershell
sharepoint 2016 content database backup restore

Step-5:
Once the backup job completes you can see the status as “No backup or restore in progress”.

Backup and Restore Content DB in SharePoint 2016 online
Backup and Restore Content DB in SharePoint 2016 online

Restore Content Database SharePoint 2013

Now that we have completed the backup we will now see the steps to restore the web application from backup files in SharePoint 2013.
Step-1:

  • Log on to SharePoint 2013 Central administration with FARM administrator account
  • Select “Backup and Restore
  • Click on “Restore from a backup” in Farm Backup and Restore Zone.
sharepoint 2013 backup and restore best practices
backup and Restore content database sharepoint 2013

Step-2:

  • Provide the backup path till you see the backup folder and .xml file
  • Click on refresh to see the backfile details
  • Click on radio button and click on “Next
Backup and Restore Content DB in SharePoint 2013 Tutorial
Backup and Restore Content DB in SharePoint 2013 Tutorial

Step-3:
Click on the checkbox of the desired content DB to be restored and say “Next”

Backup and Restore Content DB in SharePoint 2016 Tutorial
Backup and Restore Content DB in SharePoint 2016 Tutorial

Step-4:

  • Click on Same configuration option as we are restoring on the same server
  • Provide the FARM admin login details
  • Click on start restore
sharepoint 2013 backup and restore best practices
Backup and Restore content database sharepoint 2013

You may like following SharePoint backup and restore articles:



Hope this helps happy administration in SharePoint 2013 and get to know how to do backup and Restore content database sharepoint 2013/2016.

Check out Best Alternative to InfoPath -> Try Now

You May Also like the Following SharePoint Online Tutorials:

About Krishna Vandanapu

I am Krishna.Vandanapu a SharePoint architect working in IT from last 12 years, I worked in SharePoint 2007, 2010, 2013, 2016 and Office 365. I have extensive hands on experience in customizing SharePoint sites from end to end. Expertise in SharePoint migration tools like Sharegate, Doc Ave and Metalogix. Migrated SharePoint sites from SharePoint 2007 to 2010 and 2010 to 2013 several times seamlessly. Implementing CSOM with Microsoft best practices. Spent quality time in configuring SharePoint application services like User Profile, Search, Managed Meta data services etc. Now exploring SharePoint Framework and SharePoint 2019

View all posts by Krishna Vandanapu →