http://www.sqlservercentral.com/blogs/sqlsailorcom/2013/03/29/sqlserver-log-shipping-work-file-what-is-this-all-about-/

Printed 2014/09/02 07:09AM

SQLServer Log Shipping Work File ! What is this all about ?

By AnupWarrier, 2013/03/29

A short and sweet post for a gorgeous morning -

Have you seen a file with extension .wrk in the log shipping copy folder ?

Logshipping work file

What is this all about, Curious? Then here is the answer -

When the transaction log backup files are copied from the primary server to the secondary server the file is named as a work file(.wrk) till the copy operation is completed.

This will ensure that the restore job in the secondary will not pick the file and try a restore.

Once the file is completely copied, then it will be named as .trn, the one which is very familiar to us.

Logshipping work file2

Normally when the log backups are very small you wont really observe the .wrk file. In a flash they are converted to a .trn file. When the log backups are relatively bigger, then you can see .wrk file available in the copy folder for a longer period of time.

Thanks for reading and keep watching this space for more.



Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.