If you can’t restore a backup that is out of date at all then won’t you have to backup after every transaction?
Is this a possible solution? I have two computers, I use one all the time for small transactions. I occasionally sock away a large amount to my other machine just by transfering then I also immediately backup that machine’s wallet.dat to a secure place.