Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

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

The following error appears in the Job history Log in SQL Server

An error occured while trying to access the cache directory: "D:\". Inner Error ------------------> Access is denied. Process Exit Code 4. The step failed.,00:00:00,0,0,,,,0

Has any one experienced this error before?

This is occuring during MDW collection_set_2_upload

Because of this the database log Becomes full.

Any suggestions?


share|improve this question

closed as unclear what you're asking by Falcon Momot, Tom O'Connor Aug 29 '13 at 22:50

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question.If this question can be reworded to fit the rules in the help center, please edit the question.

up vote 0 down vote accepted

collection_set_2_upload seems to be a SQL Agent job related to MDW (Management Data Warehouse). Look in your SQL Agent job activity and see if you see a failed job.

Of bigger importance was the fact that your log was full. Clear that up first or you'll be going nowhere.

From your comment, dcexec is a process that collects information to store performance stats on for reporting using MDW. It could have given you that error because the log file was full.

share|improve this answer
Log was cleared. – Abby Normal Aug 29 '13 at 21:25
It is definately a failed job, its in the log. – Abby Normal Aug 29 '13 at 21:26
@Abby What's that job step trying to do? – squillman Aug 29 '13 at 21:34
dcexec -u -s 2 -i "$(ESCAPE_DQUOTE(MACH))\$(ESCAPE_DQUOTE(INST))" – Abby Normal Aug 29 '13 at 21:47
In the odd event anyone sees this and it can help them, I seemed to have figured out the problem. The "SQL USER", the one that SQL SERVER performs back -up as, needed to be given full control rights to the cache directory in question although it had full control right to the drive in question. changed that and the jobs worked normally. – Abby Normal Sep 10 '13 at 13:17

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