I have sqlbackupandftp pro 2-license installed on two boxes, A and B. I have A set to do full back every week with differentials every day. That works and the backups are sent to a S3 bucket.
After the full back up runs. I go to machine B and run restore and the full backups are restored from the s3 bucket.
However, after a couple of days I go to machine B and run restore with the “last” option from the dropdown and then I always get this error.
[Error] Failed to restore database. One or more errors occurred. > This differential backup cannot be restored because the database has not been restored to the correct earlier state.
RESTORE DATABASE is terminating abnormally.
I’ve tried deleting old diffs and leaving just the full and one diff but it doesn’t matter. I still get that error listed above.
I then have to delete all the diffs leaving just the fulls for the restore to work.
How can I resolve this issue so my differentials restore without error?