Mssql differential restoration error

After trying to restore differential backup after a full backup, i got this error message :

The log or differential backup cannot be restored because no files are ready to roll forward.

To be able to complete differential restoration, full backup needs to be restored with “WITH NORECOVERY” option as follow:

RESTORE DATABASE numberspeaks FROM DISK = 'D:\numberspeaks-full.bak' WITH NORECOVERY
RESTORE DATABASE numberspeaks FROM DISK = 'D:\numberspeaks-diff.bak' WITH RECOVERY

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.