T-SQL-Automatic-restore-of-latest-backup Easy T-SQL script to restore the latest backup of a database to another. Used for the scenario of restoring production to test on a regular basis. More information in this blog post: MS SQL: Automatically restore latest backup