I’ve worked with a couple Drupal installations of CiviCRM, and have always been able to use the Backup & Migrate feature to download a copy of the CiviCRM sql backup.
I’m working with a new customer and when I tried to restore their backup in MySQL, it does not have all the normal tables (civicrm_activity, etc.).
Has something changed with Backup & Migrate (this is version 7.x-2.8)? Are there settings I’m missing?