Log Shipping Secondary Server Restore problem

• hendra-880128

  Valued Member

  Points: 58

  More actions

  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 ?

• abhishekreddy62

  Mr or Mrs. 500

  Points: 515

  More actions

  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.