Get Even More Visitors To Your Blog, Upgrade To A Business Listing >>

How to Backup SharePoint 2013 Content Database


Windows PowerShell: 

Before using Sharepoint Central Administration first you should verify that you have the following memberships: securityadmin, db_owner, Administrators group. 

1.Start the SharePoint 2013 Management Shell by using following path:

Start>>All Programs>>Microsoft SharePoint 2013 Products>> SharePoint 2013 Management Shell. 

2.Type following command on Windows PowerShell command prompt: 

Backup-SPFarm -Directory   <BackupFolder>  -BackupMethod {Full | Differential} -Item <ContentDatabaseName> [-Verbose]

SharePoint Central Administration:

Before using SharePoint Central Administration, first you should verify that the user that is going to perform the procedure should have Farm Administrators SharePoint group membership. 

1.Start SharePoint 2013 Central Administration.

Start>>Microsoft SharePoint 2013 Products>>SharePoint 2013 Central Administration

2.In Backup and Restore section>>Perform a backup>>select Sharepoint Content Database that you want to back up>>Next.

3.In 'Backup Type section'>>Select Full or Differential.

4.In 'Backup File Location, section>>type path of the backup folder>>Start Backup.

SQL Server tools: 

Before using Sql Server Tools, first you should verify that the user that is going to perform the procedure should be member of Server db_backupoperator. 

1.Open SQL Server Management Studio
2.After that connect to the Database server.
3.Object Explorer>>expand Databases.
4.Right-click the database that you want to back up>>Tasks>>Back Up.
5.Back Up>>Backup type. 
6.In the Backup component area, click Database
7.Give a file name to the backup set. 
8.Give a expiration date to the backup set. 
9.Destination Section: location where you want to store backup>>Click OK. 

You should choose these backup options as per your requirements like if you are performing command-line administrative tasks then you should use Windows PowerShell. 


This post first appeared on An Informative Blog About SharePoint, please read the originial post: here

Share the post

How to Backup SharePoint 2013 Content Database

×

Subscribe to An Informative Blog About Sharepoint

Get updates delivered right to your inbox!

Thank you for your subscription

×