Wednesday, July 11, 2012

SQL:Msg 3117, Level 16, State 1, Line 7 The log or differential backup cannot be restored because no files are ready to rollforward.


I was recently trying to perform a restoration which includes a full database backup and transaction log to be restored on mirror server. and I came up with this little interesting problem
Msg 3117, Level 16, State 1, Line 1
The log or differential backup cannot be restored because no files are ready to roll forward.
Msg 3013, Level 16, State 1, Line 1
RESTORE LOG is terminating abnormally.
I am using SSIS package to deploy all of this for specail job to be run on mirror server and now we were restoring back. The solution is very simple
restore database <DB name> from disk=N'Your Location' with norecovery.
restore log <DB name> from disk=N'Your Location' with norecovery.
And Yes its done

1 comment:

  1. OK I was in hurry for writing this and I forget to add one last keyword.

    restore database from disk=N'Your Location' with norecovery, replace

    restore log from disk=N'Your Location' with norecovery,replace

    This should work perfect

    ReplyDelete

Popular Posts