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
How useful was this post?
Average rating / 5. Vote count: