1

I'm trying to copy a backup I've made from one server to another using either an SSIS or Powershell step in a job. I've run into the same error on both systems when running the step under the sql agent. I receive errors that the path does not exist. I've tried granting the agent rights to e:\backups, where the file is located, but it still doesn't work.

When I use a proxy for the step, it works fine.

Can anyone help me with what permissions to grant to sqlagent?

Rights look to have been granted to MSSQL$Instance1 on the backup drive.

Improve this question
1
  • Granted SQLAgent$Instance1 full rights to the e:\backups folder and still no dice. Commented Jun 28, 2012 at 22:01

1 Answer 1

Reset to default
0

Given that you indicate you are copying to E:\Backups that it represents another server, it sounds like you are using mapped drives. Whatever agent you are using is probably being run in non-interactive logon mode, which precludes the use of mapped drives. I suggest you try to use UNC paths instead, ex: \\servername\backups

Improve this answer
1
  • Yes, I didn't specify, but I am using UNC paths. Commented Jul 10, 2012 at 16:43

You must log in to answer this question.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.