For many developers, it is very appealing to add their solutions to custom databases hosted on the farm database server, as it seems a logical solution because the application or integration process is part of SharePoint. SQL Server backups are the most reliable product.
The authors recommend using a SQL Server maintenance plan schedule for full backups, or if the organization uses an enterprise schedule system, use PowerShell. See the following samples:
To perform a backup with SQL Server Management Studio, perform the following steps:
Open SQL Server Management Studio and connect to the SQL Server database instance hosting the SharePoint database that is required to be backed up.
Expand the Databases. Right-click on the name of the database, select the Tasks option when the menu opens, click on the Back Up option to open the Back Up Database dialog box.