Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have created a SQL Server Agent job (in SQL 2008 R2) to back up some databases on a server. This task runs fine when the backup folder is set to a folder on that machine, but when I try to set it to a remote folder location, it does not work. I get the rather unhelpful error Execution of job 'xxx' failed. See the history log for details. I've looked at the windows event log and I see the message `Package "DailyBackup" failed.

Is there a way to get more detailed logging? Also, is what I am trying to do even possible (i.e. write backups to a folder on another server). Note I can happily access the folder on the other server and create files etc, so I assume this is not an issue with access rights?

share|improve this question
up vote 3 down vote accepted

SQL server is referring to the SQL Server Log, not the Windows Event log.

Your SQL Agent process has no permissions to write to the remote location; you will have to grant access to the user running the SQL Agent process.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.