We do a full backup every 24 hours, a differential every 6 and a trans every hour. Today we needed to do a restore for the first time ever. We’ve tested them when we first started the app and everything went well. Today I get this error message:
“no files are ready to roll forward.”
I could only restore the full and none of the diff or trans ones. Is this a DB setting issue?
Mike_Chytracek
Thank you for the details.
The error message you get is generated by SQL Server. Please find more details about it at: https://sqlbak.com/blog/the-log-or-differential-backup-cannot-be-restored-because-no-files-are-ready-to-rollforward
Also, you can find more information on the web.
At the following blog post: https://sqlbackupandftp.com/blog/how-to-restore-sql-server-backups you can find the details about the restoration process.
Sorry for the inconvenience.