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: