You can perform three different types of backups of the SQL database: complete, differential, and incremental. You must determine what kind of backup is right for your site:
In most cases, a daily complete database backup is recommended. A complete backup makes restoring the database easier.
If the database is too big, do a complete backup on the weekend and do a differential backup daily.
If the database has a lot of transactions going on, you can do several incremental backups during the day plus a daily complete or differential backup.
 | Note: Differential and incremental backups complicate database recovery. For more information, refer to Restoring the SQL databases when differential or incremental backup jobs are enabled. |