Voxinforma:
I use a script to automatically find the lastest full backup, copy the file to a different server and restore the database. I am using LiteSpeed, so I would need to create another script for native restores to post it for those interested.
Great job, Tom!!!
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor