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.
- 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.
Select the required web application to be backed up and click on the Next button.
- 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 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
Once the backup job completes you can see the status as “No backup or restore in progress”.
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.
- 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.
- 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”
Click on the checkbox of the desired content DB to be restored and say “Next”
- Click on Same configuration option as we are restoring on the same server
- Provide the FARM admin login details
- Click on start restore
You may like following SharePoint backup and restore articles:
- SharePoint 2013 backup error We apologize for any inconvenience but we have made the site read-only while we are making some improvements
- Your backup is from a different version of Microsoft SharePoint Foundation and cannot be restored
- Backup Restore SharePoint 2013 site collection using PowerShell
- Automating Your SharePoint Online Backups
- Sharepoint Metadata Backup and restore procedure
- Export Import Sub Site using PowerShell in SharePoint 2013
- Shrink SharePoint config database transaction log files
Hope this helps happy administration in SharePoint 2013 and get to know how to do backup and Restore content database sharepoint 2013/2016.
SharePoint Online FREE Training
JOIN a FREE SharePoint Video Course (3 Part Video Series)