Compress and ship log files
Posted on 2011-09-26
Servers are running SQL 2008 STD. I need to compress the log files created by LSBACKUP job and ship them over WAN to backup (standby) server, then extract them for LSRESTORE to do it's thing. Standard LSCOPY job won't do the job because some of the trn files end up 20GB in size. However, they zip or rar down to around 100mb, which would transport much better! I need an automated solution, or a looping batch. Send server needs to only copy new files, and recipent end needs to ignore files already extracted. I hope to be able to set up regular log shipping, and then just disable the lscopy job.
Have looked at Unison file transfer, which supports compress before copy, but it could delete the recipient copy before lsrestore job applies it. Is there a command line for winrar? Need some ideas and inspiration here.