Not a very robust solution, but I do realize this is your first rodeo too. Your script works if there is only one T-Log to restore to a FULL backup. However, 99.5% of the time this is never the case in a disaster recovery scenario in production. You will probably not only have to RESTORE a FULL backup with NORECOVERY, but probably your last DIFFERENTIAL backup with NORECOVERY, as well as MANY T-Log backups with NORECOVERY to get to your last T-log with RECOVERY where the STOPAT= option would come into play. It is just a lot easier to script all this out from the backup history.:-D