I've seen that kinda setup done nicely.. Daily automated DB Backup. Daily automated DB restore to a seperate server. (Which also can kinda double as a hot spa

I've seen that kinda setup done nicely.. Daily automated DB Backup. Daily automated DB restore to a seperate server. (Which also can kinda double as a hot spare as required.)