Post reply

Log Shipping Secondary Server Restore problem

  • June 16, 2009 at 12:57 am

    #1010052

    Hi,

    I am facing the similar problem with my Log-shipping in sql 2005, with one thing additional, the MSDB database is not getting updated, I do not find any entry in the Log_Shipping_primaries and Log_Shipping secondaries tables on the MSDB? Any workthrough?

  • December 7, 2010 at 7:28 pm

    #1259876

    Hi all,

    I've done POC/testing on log shipping using SQL Server 2005, at first, it worked, but sometimes it failed in the recovery job

    I just wanna know, what are the matters that caused log shipping failed ?

    As far as I know from this topic, these case can caused log shipping failed to restore :

    - If any user connect to secondary database (log shipping DB)

    - If doing truncate log file on primary database

    - If doing backup transaction log on primary database

    - any others... ??

    And if it failed to restore the transaction log, what should I do ?

  • August 21, 2014 at 1:33 pm

    #1740024

    I got the same error long time back . I manually restored the log backup and then started the restore job. That fixed the issue.

Viewing 3 posts - 31 through 32 (of 32 total)

You must be logged in to reply to this topic. Login to reply