Backup is automated on a nightly cron. Restoring the entire DB is easy, I have a script to do it. But ya if something blows up in prod or partially blows up, ... usually the situation is you wrote some shoddy script and blew up half the database so then you have to import it somewhere else and untangle that mess. So you're quite right, can't easily be automated.