Yes - setting up automated course backups is an admin-only thing.
With your original problem, the only way forward would be to create a completely separate Moodle site from the site backup. Then use Moodle's backup and restore to recover the activity. Quite a significant task.
With your original problem, the only way forward would be to create a completely separate Moodle site from the site backup. Then use Moodle's backup and restore to recover the activity. Quite a significant task.