We did setup of a fresh log shipping for one of the customer. It was setup without any issues. Log shipping backup, copy and restore jobs were created as well. We restored full and subsequent log backups from primary to secondary for initial sync. Log shipping backup job was working fine as well. However SQL server log shipping copy job was failing continuously. We could not see any error messages in log shipping copy job history. We did not observe any errors in SQL server error logs as well. We reviewed permissions for SQL service accounts on source and destination folders. We could not find any gaps.
Please note log shipping jobs are executed through .exe file (sqllogship.exe) . We tried calling copy job step directly from command prompt to see if any errors are reported. You can copy command shown in below screenshot to execute.
Execute above command as below:
and we got the below window stating error clearly:
SQL Server log shipping copy job started working fine.
I hope it will help you guys in case observe similar issue. Please update in comments if any different issues are observed with log shipping job.
Happy Learning !