How can we help you today? How can we help you today?

COPYTO Warning 140 Error: Destination file already exists.

I'd like to use the COPYTO command to archive backup sets done on a rotation, but when the filename is reused, I get a destination file already exists error. Is there any way to set sqlbackup to overwrite existing files with the COPYTO parameter?
mrobbins
0

Comments

1 comment

Sort by
  • petey
    No. One workaround is to build an ERASE command-line script and use xp_cmdshell to delete the files prior to the backup.
    petey
    0

Add comment

Please sign in to leave a comment.