I'm trying to figure out a way to restore DB02 from the most recent backup of DB01.
RESTORE DATABASE DB02
FROM DISK = 'Z:\SQLServerBackups\DB01XXXX.bak'
But DB01XXXX.bak will always be different obviously.
Hopefully that makes sense.
This is an old SP I used to use for restoring databases automatically you might be able to take ideas from it
If we have to restore latest backups we needed to find fully qualified backup file path, then we need to find its logical names then data & log file locations all these activities need to be carried out manually.
Check this ,this will be helpful for you .
Here is a simple way to restore the database to the point in time: http://www.sqlserverlogexplorer.com/sql-server-point-in-time-restore/