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

FILEOPTION options

Hello all, I'm having some trouble with my ERASE_FILES and the threads I've found on it don't suit my needs.

Currently we are backing up directly to a UNC network path instead of using the COPYTO option (I know it's not best practice... but it's the only option for us :shock: ). Anyways, our old backup files are not getting deleted and I assume that it's because the Archive bit is still set on them? Is there an overriding option for this behavior, or will it only ever delete files that have been "archived"?

I cannot find any documentation on the FILEOPTION option 3 and am hoping that it will remove the files directly. Thanks!
dylanfinney
0

Comments

3 comments

Sort by
  • petey
    By default, SQL Backup deletes old files regardless of the archive bit status. It is only when you want to specifically delete files that do not have the archive bit set, that you would use the FILEOPTIONS option.

    Does the SQL Backup Agent service startup account have rights to delete files in that folder?

    Thanks.
    petey
    0
  • dylanfinney
    Thanks for the reply. I double checked and the account that the service runs under does have rights to delete from the network location.
    dylanfinney
    0
  • dylanfinney
    Sorry for the post! It was because the password had changed that the files weren't deleting! :oops:
    dylanfinney
    0

Add comment

Please sign in to leave a comment.