I have a transaction log shipping configured. Job activity monitor shows that both Copy and Restore steps have failed, however, I see that backup files are in fact copied across to the secondary server and also the database has been restored successfully. What is going on?

  • what does the job monitor error log say? What are the reasons in Job Agent log? – user129291 Jul 2 '18 at 5:18
  • Confirm the restore job detail does not state that logs were skipped. The SQL Agent Job will show succeed even when trn logs are not restored, but skipped due to log sequence number issues. It will not report failure if logs are skipped. – Henrico Bekker Jul 2 '18 at 5:22
  • It would be more better if the issue has been mentioned in detail. – Sunil Nepali Jul 3 '18 at 9:31

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.