O'Reilly logo

Microsoft SQL Server 2008 High Availability by Hemantgiri S. Goswami

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 7: Log Shipping

There are few errors we may encounter with Log Shipping and most of them can be easily resolved. To get them resolved, we can get help from job history. Let's see this with the help of an example.

Frequently asked questions

  • Question 1: Why do we get the following error?

    Log Shipping is Out of Sync

    We have to dig the SQL Server Error Log and Job History to get more information. Follow these steps to troubleshoot the error:

    1. Expand the Job Activity Monitor, right-click on the job, and click View history.
      Frequently asked questions
    2. As we can see in the error message here, it says that the T-Log restore job has failed to restore the T-Log and is out of sync ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required