Backup and Restore Content DB in SharePoint 2013

Backup and Restore Content DB in SharePoint 2016

Objective:
In this article I would like to walk you through one of the important process every admin should in SharePoint technology. In SharePoint we can perform this back up restore in 3 ways:
1. SharePoint Central Administrator
2. PowerShell scripts
3. SQL Server Management studio
Here we will discuss about the “Central Administrator 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 behavior is adverse than expected we should be able to restore old environment.
Backup:
The first step is to take the back of the desired web application.
Step-1:
a. Log on to central administration with FARM administrator account
b. Click on “Backup and Restore” option as shown in screen shot
c. Select “Perform a backup” option from “Farm Backup and Restore” zone.
Backup and Restore Content DB in SharePoint 2013
Backup and Restore Content DB in SharePoint 2013
Step-2:
Select the required web application to be backed up and click on Next button.



Backup and Restore Content DB in SharePoint 2016
Backup and Restore Content DB in SharePoint 2016
Step-3:
a. Ensure that backup web application is selected as desired
b. Select Full / Differential as per the need
c. Provide the backup to create the backup files
Note: This path must be a universal notation like \\servername\foldername
d. Click on “Start Backup”
Backup and Restore Content DB in SharePoint 2010
Backup and Restore Content DB in SharePoint 2010
Step-4:
1. SharePoint shows who requested this backup
2. It shows the name of the web application the content DB is currently associated with
3. Back directory path which we provided as part of step-2
4. All the custom & Generic solutions deployed in the source web application
5. Since we have initiated the backup job it is showing as A backup or restore is in currently in progress
Backup and Restore Content DB in SharePoint 2013 online
Backup and Restore Content DB in SharePoint 2013 online
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 the Content Database:

Now that we have completed the backup we will now see the steps to restore the web application from backup files.
Step-1:
a. Log on to Central administration with FARM administrator account
b. Select “Backup and Restore”
c. Click on “Restore from a backup” in Farm Backup and Restore Zone.



Backup and Restore Content DB in SharePoint 2010 online
Backup and Restore Content DB in SharePoint 2010 online
Step-2:
a. Provide the backup path till you see the backup folder and .xml file
b. Click on refresh to see the back file details
c. 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 check box 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:
a. Click on Same configuration option as we are restoring on the same server
b. Provide the FARM admin login details
c. Click on start restore
Backup and Restore Content DB in SharePoint 2010 Tutorial
Backup and Restore Content DB in SharePoint 2010 Tutorial

Hope this helps happy administration in SharePoint 2013.

Similar SharePoint 2013 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 →

Leave a Reply