separate COPYTO actions from commands

meastland

After reading through the online help for SQL Backup, I notice that it is possible to separate the ERASE commands from the backup jobs. I was wondering if it is also possible to do this with the COPYTO commands? The reason I ask is because copying to the remote fileserver in my environment is causing the backup jobs to run much longer than normal. I would like to try separating the copy steps from the core backup jobs to see if I can work around this issue. I realize that I can code something outside of SQL Backup to copy the files on a scheduled basis, but I was wondering if there was a way to do this using any part of the SQL Backup toolset.

Thanks in advance for any suggestions.

James B

Thanks for your post.
Unfortunately I don't believe it's possible to get the COPYTO to run asynchronously from the backup command itself - it's an interesting idea though, and I'll double check it with the Backup team to make sure it's not something we're already looking at.

petey

James is right, we do not have any commands that will allow you to run COPYTO as a standalone process. We do offer a couple of standalone utilities, Copytool and Ftptool, to do that. You can read more about them here.