I have setup transaction log shipping between two servers every 15 minutes, this is on SQL Server 2008 R2. The problem is that when the logs are being restored on the secondary server, it always uses the second-most-recent log file rather than the most recent one available. I suspect this is because the restore happens at the same time the backup occurs on the primary server. I thought I could use the "delay" option to get around this, but it doesn't seem to do the trick. What am I missing?