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.
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
OK I was in hurry for writing this and I forget to add one last keyword.
ReplyDeleterestore database from disk=N'Your Location' with norecovery, replace
restore log from disk=N'Your Location' with norecovery,replace
This should work perfect