.wrk file in Logshipping 2005

This is about SQLServer 2005 Logshipping.

I am looking at Logshiping folder and seeing huge file like DBName_20070313210008.wrk

Any Idea? what the file is about

Thanks

--

Farhan

Do you see many files or only 1file?|||Only one.|||

The .wrk files are produced when the transaction log backups are copied from the backup location to the secondary server (by the agent job on the secondary). The files are named .wrk during the copy operation; when they have been completely copied they are renamed to have the .trn extension. The temporary naming using the .wrk extension ensures that the files are not picked up by the restore job until successfully copied.

So, if the .wrk file you are seeing is there all the time it is likely to be an old copy that failed for some reason. So for normal operation, you'll see a .wrk file when each transaction log backup file is copied and then that will be renamed to a .trn file.