Post reply

Restore log file fails 3117

  • 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!

  • 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

  • September 26, 2017 at 4:15 pm

    #1961071

    I see. Thanks!

Viewing 3 posts - 1 through 2 (of 2 total)

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