Have sql agent job for log shipping copy step that fails every once in a while with "Reason: access is denied" but no other detail.

Here is what the failing step looks like:

"C:\Program Files\Microsoft SQL Server\120\Tools\Binn\sqllogship.exe" -Copy DEF49099-4526-ABCD-83AE-E00F5C221E74 -server MyServer

Job runs every 15 minutes but fails maybe once a day. SQL Agent service running as domain user. How can I drill down further on this intermittent failure.

Microsoft SQL Server 2014 (SP2-CU10-GDR) (KB4052725) - 12.0.5571.0 (X64) Standard Edition (64-bit) on Windows NT 6.3 (Build 9600: )

  • Is there any different windows log (event viewer) at the same moment? – Ronaldo Sep 24 '20 at 16:33

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.