Restore log file fails 3117

• spuyear

  Old Hand

  Points: 309

  More actions

  September 26, 2017 at 9:41 am

  #325556

  Thanks to GilaMonster I was able to recover a database thought lost. The method of hack attaching the database worked.

  I am now trying to restore the log file (trn) and am getting a 3117 error:

  Msg 3117, Level 16, State 1, Line 1
  The log or differential backup cannot be restored because no files are ready to rollforward.
  Msg 3013, Level 16, State 1, Line 1
  RESTORE LOG is terminating abnormally.

  How do I restore the log file backup to avoid this error?

  Thanks!

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  Follow

  September 26, 2017 at 10:36 am

  #1960999

  From the previous thread:

  Then, restore the full backup WITH NORECOVERY, restore any log backups taken since the full backup followed by the one you took from the hack-attached DB. Restore the last one WITH RECOVERY and you should be up an running with no data loss.

  Once a database has been brought online, no further log backups can be restored.

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• spuyear

  Old Hand

  Points: 309

  More actions

  September 26, 2017 at 4:15 pm

  #1961071

  I see. Thanks!