How to Backup SharePoint 2013 Content Database

Same as SharePoint Server 2007 & 2010, We can back up & restore SharePoint Content Database by using three options in SharePoint 2013:SharePoint Central Administration, Windows PowerShell, SQL Server tools. As we all know that Regularly backing up database reduce the data loss, same applicable for SharePoint content database also, You should regularly update  SharePoint content database backup. Here are steps 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.