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?
Converting my comment to answer:
can change the restore frequency to be more frequent on secondary server, but then it wont keep up with the 15 min frequency of backups on primary server. Logshipping will pick up the logs (.trn and not the .wrk files) to restore