I have started log shipping for few dbs from production to DR recently, but it seems like the jobs just keep running and sometimes the copy job copies few files, sometimes it says the files already exists, the restore job sometimes says skipping backup files and sometimes restores the files , i feel it has something to do with "last_restored_file from msdb.dbo.log_shipping_monitor_secondary " being NULL, i am not sure why its not being populated by the monitor server.

Any ideas?

  • is logshipping working fine ? may be its broken due to log file missing ?
    – Kin Shah
    Sep 30, 2016 at 15:40
  • No i have checked its not erroring out,
    – user107077
    Sep 30, 2016 at 15:45

1 Answer 1


Found the answer finally, The logshipping linked server between monitor and Secondary server was not working, Opened up rules on firewall to let them communicate. Started working

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.