• Its easy if you script it!  We take log backups every 15 minutes.  95 log backups in a single day (skip the time that the full starts).  So, manual restores are NOT something that I want to do!  I wrote a procedure that creates the restore statements for me.  Give it a database name, start time, stop time, and a "restoreas" name, and it creates all of the restore tlog statements including the last one with the "stopat".  Then creates a "restore database with recovery" to run when it finishes.

    Let me know if you'd like to have it.

    Steve