Log shipping not releasing files

[timscronin]

I run log shipping to 2 other servers, one in close vicinity to the primary, and the other back to our HQ across a T1 line. Fairly regularly we get the error below when restoring the log files
18204 :
BackupDiskFile::OpenMedia: Backup device 'F:\sqltrn\RX_tlog_200601161000.TRN' failed to open. Operating system error = 32(The process cannot access the file because it is being used by another process.).

This will fail several times on the scheduled intervals until we manually run the restore job. Anyone else had this problem before?

 

[cyno]

Looks like to me while one process is restoring the database it holds lock on the file and at the same time other process is trying to access the file. How big are the .TRN files???

Cyno

 

[timscronin]

Fixed it by setting the latency to 3 minutes after file copied. It is more of an issue of the OS of the primary server not releasing the file after copy