DatabaseBackup – USER_DATABASES – LOG: This job fails saying "Executed as user: Domain\XXXX-SVC. Unable to open Step output file. The step failed."
The error is only with LOG backup job.
The other DatabaseBackup jobs (FULL, DIFF) works just fine with same SVC account. So the service account have appropriate permissions.
The Output File(Job Step properties–>Advanced) is F:\SQLAgentLog\ which is same for all jobs. Only problem is with LOG backup job. Has anyone else experienced this and is there any solution?
Current environment:
SQL Server: 2012 SP3 CU8
OS: Windows Server 2012
Note: This was working all good on a Windows Server 2008!!
Best Answer
It turns out that the person migrated the jobs from old server to new server edited the jobs manually.
One of the edit was to
"Output File: (Job Step properties-->Advanced)"
this was set to default log locationC:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Log
on old server.On the migrated server it was edited to
"F:\SQLAgentLog\Log\"
where the directoryLog
did not exist. (that person missed deleting theLog
text in the path)On the other jobs (FULL and DIFF) the text
Log
had been removed so it was set like this"F:\SQLAgentLog\"
and these both were working fine!