<<TravisDBA

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. .....>>

Thank you for your feedback. I agree with your reply. On production server, you will have a full backup, then differential backup and bunch of transaction log backups to restore point in time. This script was used to restore DEV database. I take full backup of DEV database and recycle them every week. So,I didn't have any differential/transaction log backups. You are right that this may not be the case always. This script can be used as one of many solutions out there when someone is in same situation as mine.