I, personally, use sp_restorecriptgenie by Paul Brewer. Here's the link to the SCC artciel that has it. Under 'The Procedure' http://www.sqlservercentral.com/articles/Restore+database/95839/ Basically, once you build the sproc, just run `exec sp_restorescriptgenie` and the script will go out and get all backups for every DB (even transaction logs) and give you a script to generate them.