Hmm, I'm trying out this 3rd-party app:
UtilityLock
http://semaja2.net/utilitylockinfo/
it's an alternative to Apple's password-required-on-wake, and I think it may provide a way to make automated backups happen also.
i'll report back if i get everything to work.