In my long tradition of releasing odd utilities (ok, utility) that no one but me uses I think I've come up with a winner. On one of my projects we've created an extensive database build process using NAnt. This process creates the database with all its objects and runs a series of jobs to populate data. Much of that data comes from other databases on the same server. At the start of the build process we need to restore a series of database backups as of specific dates. Since this script can run against a variety of developer workstations, test servers, QA servers, etc. we need to restore these backups into a variety of directories.
This is a companion discussion topic for the original entry at http://billg.sqlteam.com/2005/04/21/restoredb/