asked on

Log shipping- Restore Job Error

Hi there,
We have log shipping for 4 databases which are going well but however only Restore Jobs for two databases gets failed in DR environment occasionally. The error message says like this
Executed as user: xxxxxxxxx. The process could not be created for step 1 of job 0x867837754D077D4A9BFF608D000072BD (reason: 5). The step failed.

I have configured the Job->Step->Advanced->output file to capture the error message but this error was not written in the output file as well. In fact this error doesn't seem to be happened at all as I can see the output file has only log which is written before the last run which was failed.

thanks
Deepak

Daniel_PL

Hi,

I'm not sure you still have this problem. If you still experience this issue please check how big transaction log file is at the time job fails.
I didn't find reason 5 documented, I think it may just mean System Error 5 which is access denied. In this case that means your file is in use, maybe by copying process due to its size or by some antivirus software.

You can take a look at log shipping history table.

SELECT  *
FROM    msdb.dbo.log_shipping_monitor_history_detail

Open in new window

This question needs an answer!

Become an EE member today

7 DAY FREE TRIAL

Members can start a 7-Day Free trial then enjoy unlimited access to the platform.

View membership options

Learn why we charge membership fees

We get it - no one likes a content blocker. Take one extra minute and find out why we block content.