SQL Server Performance

Log Shipping Status Shows Executing Permenantly

Discussion in 'SQL Server Log Shipping' started by mshad, Feb 1, 2006.

  1. mshad New Member

    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.
  2. chetanjain04 Member

    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

Share This Page