Error : Msg 3117, Level 16, State 4 The log or differential backup cannot be restored because no files are ready to rollforward
I restored a Full backup and then tried restoring a transaction log with NORECOVERY and thats how i obtained this error. And that exactly is the issue.
Inorder for trn logs to be restored, full backup restore should have been done with NORECOVERY.
Perform it that way and restores work like charm.
MvM
No comments:
Post a Comment