Quote:
Originally Posted by Sydney's Mom
I agree, but where does it end? I recently had info on a laptop and a backup drive. I got a new computer. While moving the info, both the laptop and the backup crashed. I was finally able to move everything to a new backup, but then I was left with only 2. I bought another, but who would have thought a computer and a backup would quit at the same time. What about a computer and two backups?
|
What did we learn here? Always allow the time to validate your backup...but if it helps, back about 1992 I was IT Director for an E&R 500 company that had an job cost accounting system running on a SunIx box, a SPARCStation II as I recall...anyway, we did daily backups and kept a year's worth just in case (after a year the idea back then was since the data was still in the actual DB even when deleted, we could always get it back if need be)...anyway, I did all the right stuff, setup the backups, spent hours on the phone with the vendor, we verified the test and live backups over a week just to be sure...then a year went by...I forget exactly what happened but the DB was corrupted somehow, I mean really buggered, and not just the indexes, everything...soooo, no problem, all I needed to do was restore from the backups...problem was, none of them had data...seems something in the OS AND the app was holding a DB/index open and locking the WHOLE database and the backup app was just bouncing off not even reporting there was an exception encountered. It took the vendor over a week to reconstruct our data from what we had and we lost about 2-months of data entry.
What happened? It ended up being our branch offices were sending their data to corporate and when that happened the DB was locked and left locked after the import happened because the OS was not recognizing that the remote user was logged out of the app...and this was all automated, some of which I wrote (the remote access side) and some the vendor and of course there was that version of Solaris from Sun...
So, no matter how much you test, you never know what is really going to happen.