Just in case someone comes here who has the Auto Attendance block installed, you must have both the module and block in a course or the backup will fail with this generic error. Caught this by enabling debugging and checking the apache logs ->
Default exception handler: Table "autoattendmod" does not exist