Creating additional database backups

Issue

I want to create additional database backups on a more frequent basis.

Resolution

This can be accomplished and scheduled by following these steps:

1. Craft a command using drush sql-dump and confirm it works.
   
   Example command:

   drush @sitename.environment sql-dump > /mnt/gfs/${AH_SITE_NAME}/backups/on-demand/$(date +"%Y-%m-%d-%H%M%S").sql

   This takes a database backup every 4 hours and outputs to your on-demand directory in /mnt/gfs.

2. Add to Scheduled Jobs