SQL Server Performance Forum – Threads Archive

Log Shipping Status Shows Executing Permenantly

I have setup Simple Log Shipping between our Production and Standby servers. It is working fine. I have scheduled the job to run every 10 minutes. It is working but it shows the status executing all the time. Therefore I am not able to see the job log. Please advise.

check in msdb.dbo.log_shipping_plan_history table. It could be that your backup is taking closer to 10 min. and hence it is showing executing status.. best regards, Chetan

]]>