0

I am running a script I run on all my SQL servers however on this specific server I have run into the problem where the script fails to make a copy of the DB backups in an external location because the script gets access denied on the newly created local database backups.

For whatever reason, the backups do no inherit NTFS permissions and use the permissions associated with the database.

Improve this question

1 Answer 1

Reset to default
1

What is the login account that is running the script? You have to make sure that the login running the script, whether it is SQL Agent account or some other account has write permissions on the folder where you are copying the files to.

Improve this answer
1
  • That was the actual problem, I forgot to delete this question. Thanks though!
    – ZZ9
    Jun 30, 2015 at 13:30

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .