Chris, first let me thank you for this contribution, you have saved me literally days of work and its far better than I could have achieved on my own.

I have one small problem with it though. When gzip is called to zip up the BAK files it occasionally fails to delete the original file and therefore causes and error email to be sent.

I am using a Job running iunder the SQL Server agent and its last step is to also FTP and then MOVE the files. The MOVE command also returns an errorlevel (despite succeeding).

I suspect that this issue is caused by attempting to delete a file (i.e. a backup) that is still open.

Have you come across this problem and/or do you have any suggestions to get around it?

Many Thanks,

Jason