MarkTJohnson wrote:
how long were you "puckered"?
I would have been puckered if I had truly needed those backups. As it was, I went through a few emotions: 0: Surprise! Your false sense of security has just been shattered...You are not as clever as you thought you were, and your backups are shite! :omg: 1: Doubt...Hmmm what about the other 20 daily backups? Are they all shite? :confused: 2: Relief...Whew! The other backups are fine. Just these two from this server are crap. 3: Annoyance. I just want to get on with work. Now I have to log on Azure, allow myself to RDP into that box, get raw unzipped backups, and start troubleshooting the problem. 4: Sleuth Mode...the problem seems to be with the zip lib...maybe a bug...maybe fixed? Go get the latest version to find that it's being deprecated, and the last version is 6 y/o. Whatever, I'll try it. 5: Disappointment. :sigh: Nope that didn't work, time to open the project and debug with one of the dbs having the issues. 6: Excitement. :-D Yay! I was able to replicate the issue...now on to understanding. 7: Discovery: A well-phrased search put me on the right track...a known issue with an easy fix. 8: Humility: I'm sure I would have discovered this eventually, but I put a lot of faith in an automated process without actually verifying the outputs, which was the only way to detect the problem. Lesson learned! :laugh:
"Go forth into the source" - Neal Morse "Hope is contagious"