• Was just wondering, is there no way for me to specify a specific date and time while doing the restore.

    If for example I had 40 transaction log backups and wanted the latest log to be restored does this mean I would have to restore 39 transaction logs with norecovery (which were backed up previously) before I could reach the one I want?

    Is there not a quicker way of doing this instead of going through and restoring one at a time?