Slashdot Mirror


So You've Lost a $38 Billion File

smooth wombat writes "Imagine you're reformatting a hard drive so you can do a clean install but then realize that you have also reformatted the back up hard drive. No problem. You reach for your back up tapes only to find out that the information on the tapes is unreadable. Now imagine the information that is lost was worth $38 billion. This scenario is apparently what happened in July to the Alaska Department of Revenue. From the article: 'Nine months worth of information concerning the yearly payout from the Alaska Permanent Fund was gone: some 800,000 electronic images that had been painstakingly scanned into the system months earlier, the 2006 paper applications that people had either mailed in or filed over the counter, and supporting documentation such as birth certificates and proof of residence.' Using the 300 cardboard boxes containing all the information, staff worked overtime for several months to rescan everything at an additional cost of $200,000."

47 of 511 comments (clear)

  1. Time for... by Short+Circuit · · Score: 5, Funny
    1. Re:Time for... by Rakshasa+Taisab · · Score: 4, Funny

      Thanks for alleviating my ignorance.

      --
      - These characters were randomly selected.
    2. Re:Time for... by Anonymous Coward · · Score: 5, Funny

      I once deleted a file worth $38 billion. I was afraid my boss was going to fire me, but he shook my hand and laughed "Fire you?!! We just invested $38 billion in your education! We can't fire you after that kind of investment." And true enough, I never deleted a file worth that much again.

    3. Re:Time for... by jadavis · · Score: 5, Insightful

      It was actually only worth $200k, since that's the amount of money it took to recover from the problem.

      The fact that it was related to an account worth $38B is scary, but not the actual cost.

      --
      Social scientists are inspired by theories; scientists are humbled by facts.
    4. Re:Time for... by nelsonal · · Score: 4, Interesting

      It has to be worth more than $200k (or else the would have just written off the file). I agree that the info isn't worth the $38B though. The account would still be there even if those transactions weren't. That said I thought all the states learned the lesson of 9/11 of remote offsite backups especially in a state as geologically active as Alaska. Hope the warehouse with the paper isn't near the data center...

      --
      Degaussing scares the bad magnetism out of the monitor and fills it with good karma.
  2. Redo the work? by Anonymous Coward · · Score: 5, Insightful

    For that kind of money, I'd probably just send the HD to data recovery specialists.

    1. Re:Redo the work? by omeomi · · Score: 4, Insightful

      For that kind of money, I'd probably just send the HD to data recovery specialists.

      Well, this is the government. They probably didn't have a budget for data recovery, but they did have a budget for scanning documents...the actual dollar amounts of each probably matter very little ;-)

    2. Re:Redo the work? by Solder+Fumes · · Score: 3, Funny

      No kidding...if "Mary" from Dell "canna fiss eet, you drag to reee-cyc bin yesss? reboot? all gone, have nice day now" then who are we mortals to argue?

    3. Re:Redo the work? by sumdumass · · Score: 3, Interesting

      Nah, Nothing like that. It isn't really exciting either. I cannot really give any names or anything. But I can generically describe what happened.

      A law firm handed me a computer that wouldn't boot. On it was some pictures taken concerning a wrongful death case. It turns out that the pictures were a hindsight and in the middle of fixing it, The task turned from getting the computer to run to getting the pictures from the drive. The drive was failing and was larger then the 137gig 28bit LBA limits. But we didn't know this because it was never booted and XP pre SP1 did not enable 48bit addressing by default. And even after SP1, if you didn't update your ATAPI driver to x.1135 or later, it wouldn't be enabled by default even if you have the ability. So connecting it to another computer made it worse. Eventually the fault in the drive which was a crashed head, made it impossible for us to recover past the boot sector running traditional recovery software. The data recovery specialist were able to get around everything we added to the problem as well as the problem itself and retrieved better then 98% of everything on the drive. I think one file was bad but we weren't concerned with it at all.

      Long story short, the pictures showed someone's negligence in a wrongful death case and once they were presented or added to the evidence pile, the defendant's insurance company settled for 2 mill. The lawsuit was for more then that so you could probably guess what it could have been worth. The firms cut was in the area of 40% from what I understand. So it was worth 40% of 2 mill to them. $2500 seems like a little amount in comparison.

  3. The Senator by jeevesbond · · Score: 3, Funny

    Senator Ted Stevens remarked that they should have sent it in an Internet, apparently tubes are much more reliable than tape.

    --
    I'm going to transform myself into a mighty hawk. Either that or I'll just go and work at Dixons, haven't decided yet.
  4. And this is why... by bobetov · · Score: 3, Interesting

    ...print will never be dead.

    --
    Looking for a Rails developer in Chapel Hill?
    1. Re:And this is why... by imboboage0 · · Score: 3, Funny
      --
      Honesty may be the best policy, but by process of elimination, dishonesty is the second best policy.
    2. Re:And this is why... by evilviper · · Score: 4, Funny

      And this is why... ...print will never be dead.

      Right, because:

      Nobody has ever thrown away papers that were actually needed...

      Paper is an inexpensive and compact way to store terabytes of information...

      Paper is trivially easy to instantly duplicate on a large scale...

      Paper is trivially easy to haul off-site and store...

      People constantly generate diffs between the most recently archived paper copy, and all work they have done every day since. They don't just make undocumented changes, willy-nilly, requiring just as much effort to backup daily changes as it is to backup full copies of everything...

      No question, paper is superior. The data retention problems we always hear about are in every way caused by digital storage methods, and have nothing to do with the policies and people running the organizations...

      (No I will not pay for any damaged caused by this post overloading your sarcasm meter.)
      --
      Slashdot gets worse every day... Pipedot: News for nerds, without the corporate slant
  5. $38 billion? by pipatron · · Score: 4, Insightful

    How did they figure these files were worth $38 billion when it only cost $200000 to create them from scratch?

    --
    c++; /* this makes c bigger but returns the old value */
    1. Re:$38 billion? by stoolpigeon · · Score: 3, Informative

      right - the account is worth 38 billion - the file was apparently worth about 200 grand in labor. of course it didn't cost that much to make the first time, as it was done over a longer period without all the o.t.

      --
      It's hard to believe that's how Micronians are made. Why don't we see it right now by having you both kiss one another?
    2. Re:$38 billion? by 192939495969798999 · · Score: 3, Funny

      The method for arriving at that figure was also tragically lost. A team of monkeys recreated the figure in 3 minutes with a number pad at a cost of $45.

      --
      stuff |
    3. Re:$38 billion? by __aapbzv4610 · · Score: 4, Insightful

      The value is based on what the data represents, not the material labor in re-scanning them. loose example, I could spen $30 on painting supplies and create a $100,000 masterpiece (well not by me, but, anyway...)

  6. Re:Tapes? by MindStalker · · Score: 4, Informative

    Yea, tape is pretty common. DVD burners simply aren't rated for backups as some burned DVDs don't have a very long shelf life. Now sounds like some screwed up in purchasing cheap tapes as well. Oh no.

    BTW article is silly, the file isn't worth $38 billion $200K at best because thats the cost of rescanning everything. Would be interesting to see an accounting record of how much recreating all the documents would cost had they not had a hard copy.

  7. Re:Tapes? by teflaime · · Score: 3, Insightful

    Most ENTERPRISES still have tape at some level as part of a comprehensive disaster recovery plan. Tape is easy to offsite, fairly reliable overall and still have comprehensive support available in all platforms. Most INDIVIDUALS don't do backups at all.

  8. I'll do it! by mwvdlee · · Score: 5, Funny

    So the information is still available in 300 boxes and it would cost about $200,000 to scan and recreate the $38 billion file again?
    I'll do it for $1 billion.

    --
    Slashdot social media options: AIM, ICQ, Yahoo, Jabber and Mobile Text. Why no MySpace?
  9. maxtor? by ElephanTS · · Score: 4, Funny

    As their IT consultant I stand by my use of Maxtor drives.

    --
    spoonerize "magic trackpad"
  10. Re:Tapes? by greginnj · · Score: 5, Informative

    Really? For what volume of data? For people with 100s of GB of transactional data, tape robots are pretty much the only option, or you'll be spending your whole day swapping DVDs. OTOH, it sounds like this was relatively static data (since it could be re-entered from paper), so maybe a DVD version would have been an appropriate measure as well. There's also a lesson here that you should frequently do test restores from backup tapes.

    --
    Read the best of all of Slash: seenonslash.com
  11. Backups are the devil by Maxo-Texas · · Score: 5, Insightful

    Because no one ever restores them regularly to test them.

    I was at a company years ago and argued for both a ton more backups than they were making and for a test restore. They were not in the mood to do either. After about nine months, for some unknown reason they had to restore a file.

    And the backup tape was unreadable. The next good backup was 17 days older.

    After that we got $30 bucks of backup tapes every week and we had a 7 day rotation with the 7th day going in the vault. And we did regular test restores once a quarter.

    You should REGULARLY test your backups.
    You should have LOTS of backups.

    --
    She was like chocolate when she drank... semi-sweet at first and then increasingly bitter.
  12. I'd hate to be the tech support guy... by condour75 · · Score: 4, Funny

    And it's not in the recycle bin? Ok, let's not panic. Click start, go to find, choose files and folders...

  13. Re:Tapes? by daeg · · Score: 4, Insightful

    Hm. Tapes with a proven shelf life of many, many years, or DVDs where a single scratch can render 4GB of data worthless. I wonder which enterprises (or governments) should chose?

  14. Damn! by Penguinisto · · Score: 4, Insightful
    That has got to rank up there w/ the all-time worst 'oh-shit' moments in that poor bastard's career (if it still exists). I wonder what the sysadmin was thinking, storing data on the same partition as the OS. No sane production environment rig that I know of would (or at least should) have that. It may be a Windows thing, but on most servers I've dinked with, the OS sat on a pair of RAID disks by itself, and all the data sat on the monster pile of disks on their own logical RAID drive (at least RAID 5... 5+0 w/ a hot spare preferred).

    That, or you'd think they'd at least have that kind of stuff stored on more than one server if it were that valuable?

    /P

    --
    Quo usque tandem abutere, Nimbus, patientia nostra?
  15. Re:Tapes? by Red+Flayer · · Score: 4, Insightful

    Well, the summary states that the files were rescanned at a cost of $200,000 -- so it sure sounds like the hard copies were preserved.

    --
    "Trolls they were, but filled with the evil will of their master: a fell race..." -- J.R.R. Tolkien on Olog-hai
  16. Re:Tapes? by Itninja · · Score: 4, Insightful

    Easy to offsite???

    I work for an IT organization and we pay a company called Iron Mountain $100's monthly to schlep our boxes and boxes of backup tapes to their offsite storage facility.

    And remember there is a difference between making 'backups' (store my important files somewhere else so I can get them in case of a system failure) and preparing for 'disaster recovery' (store everyones files somewhere else so we can rebuild the entire infrastructure in case the building burns to the ground).

    --
    I judt got a nre Kinesis keybiartf so please excusr ant egregiou typos.
  17. Data recovery? by evilviper · · Score: 4, Interesting

    With hard drives, data doesn't just go away. Sure, it may not be recoverable with simple "undelete" software, but data recovery experts will charge far less than $200,000 to pull important files off of a wiped hard drive.

    The same goes for tapes. There is no mention in the article of why they were "unreadable" what level of damage there was to the data, etc.

    We all make mistakes, but 3 layers of backup data storage all failing suggests a horrifically poor system in-place. Not JUST "very bad," that's hard to believe, without some massive natural disaster causing it.

    --
    Slashdot gets worse every day... Pipedot: News for nerds, without the corporate slant
  18. Not to bad by geekoid · · Score: 3, Informative

    That they cuold get recovery for only 200K.

    I know that many companies would not be able to recover information lost in that manner.

    I worked for a company that had not had a back up, at ALL for 4 years. All there business was lectronic. If the system had crashed there company would die. I spent 6 mopnths trying to them to pay for a back up system. FInally the provided a tape drive thawas 5 years old and completly inadequate... I decided to go elsewhere.

    --
    The Kruger Dunning explains most post on /. http://en.wikipedia.org/wiki/Dunning%E2%80%93Kruger_effect
  19. I lost 75 trillion dollars! by 140Mandak262Jamuna · · Score: 4, Funny
    I launched notepad and wrote 75 trillion dollars and saved the file. And, because I was feeling very extravagent, I deleted the file. I am rich. I can afford to lose 75 trillion dollars without batting and eyelid and am man enough to brag the info to the whole world.

    Come on guys, it took only 200,000$ to create the data. It probably had records of payments totalling 38 billion dollars. But what they lost was 200,000$ not 38 billion dollars.

    --
    sed -e 's/Chuck Norris/Rajnikant/g' joke > fact
  20. Re:I could be a douche and say it has never happen by Overzeetop · · Score: 4, Insightful

    What happens when you fuck up that big? If you the CEO of a major corporation, you get a severance check that looks like a phone number. If you're the IT plebe, you get to look for a new job.
    --
    Is it just my observation, or are there way too many stupid people in the world?
  21. Re:Actual Cost?? by ClickOnThis · · Score: 3, Informative

    Err.... if it only cost $200,000 to replace the data, where the hell does the $38 Billion figure come from?

    The site is slashdotted, so I can't read TFA, but my guess would be the information isn't actually "worth" $38B. It just represents an accounted amount of $38B.

    The actual value of the data is what it would cost to replace it (or perhaps do without it) -- in this case, $200,000. Consider an analogy (20th-century, but illustrative): if you were to send a paper bank-check for $10,000 via a courier, the declared value for insurance would not be $10,000. It would be the cost of recovering from the loss of the check, which would be the stop-payment fee plus the cost of sending a new one.

    --
    If it weren't for deadlines, nothing would be late.
  22. Re:Data recovery? by mwvdlee · · Score: 4, Insightful

    I'm just assuming the harddisks were secure erased, considering that is what pretty much every govenment in the world does when formatting harddisks.

    Simply put, secure erasing is a process whereby (semi-)random data is written to the harddisk, overwriting previous data, and doing it enough times to ensure no residual traces of data exists.

    --
    Slashdot social media options: AIM, ICQ, Yahoo, Jabber and Mobile Text. Why no MySpace?
  23. Re:Actual Cost?? by saigon_from_europe · · Score: 4, Funny

    1) Write "200 000 000 000 USD" on the paper.
    2) Type what's on the paper into a .txt file
    3) Save the file
    4) Delete the file
    5) Empty the recycle bin
    6) Recreate file by retyping data from the paper
    7) Post the story on the /. how big financial disaster you've made, and how you've saved your ass

    --
    No sig today.
  24. Someone is trying to cover their ass by Unique2 · · Score: 5, Insightful

    Primary disk: Accidently deleted.
    Backup disk: Accidently formatted.
    Tape: Unreadable.

    What about the other tapes in the cycle? Did you not test it before? What about data recovery on the hard disks?

    Thats a lot of unfortunate co-incidents and a lot of questions. It sounds more like the reality is that none of these ever existed and someone got caught-out.

    --
    No trees were harmed in the posting of this message. However, a great number of electrons were terribly inconvenienced.
    1. Re:Someone is trying to cover their ass by AK+Marc · · Score: 4, Informative

      It sounds more like the reality is that none of these ever existed and someone got caught-out.

      Having worked on backups in an Alaskan company run very similarly to the department in question, I think it sounds reasonable. I was a consultant at the time, and I pointed out that the backups have never been tested. It was on the weekly report. It was on the weekly report for about a year. Many people making much more than you make saw that the backups have never been tested. Then there was a crash. It turned out that the backups, set up long before I got there, were set in a tape library. There were 5 tapes and a cleaning tape. The backups would backup server 1 onto tape 1. Then, server 2 onto tape on - set to overwrite. The least important server in the room was last on the backup list, and it was the last to issue the command every night to backup onto tape 1 - set to overwrite. So the email was gone forever. Somehow, the consulting company I work for that pointed out for over a year that backups weren't tested and may not work was to blame for not fixing what was broken long before we were brought in. So I find the description of events quite plausible.

  25. Re:Tapes? by Sobrique · · Score: 5, Informative
    In a backup system where you're taking full backups once a week, even with no data churn at all, you end up backing 1/7th of your estate every night. Starts getting a real challenge at about the 15Tb mark, and becomes a whole new adventure in pain when you're talking 100-200Tb.

    And then of course, you have 'churn' to worry about. Now, my company does use disk as part of it's backup strategy. Backup to disk and snapshot copies are valuable.

    But, well, if you're doing full backups weekly, incremental (or differential) daily, then you're in practice backing up 450% of your 'live' storage every month.

    Even onto 'cheap' disk, that gets spendy _very_ fast. That's even before you consider the need to offsite your data for disaster recovery. Tape's still the only real viable way of doing that in bulk. Whilst you can replicate storage arrays, the hardware and bandwidth to do this is also horrifically expensive, especially if you're doing that 1-for-1.

    Some people do. Where I work at the moment, 4 of everything is bought, and that includes storage. 1 for dev, one for test, one for production and one for DR. But this kind of thing, does not come cheap, and ... well, no one's going to spend that kind of sum of money (millions) trivially.

  26. Re:Tapes? by Philosinfinity · · Score: 4, Interesting

    Not even close. We use LTO2 tapes and keep them offsite for 18 months. We've run several test recoveries on tapes > 12 months old with success. Some of our tapes have been in circulation for about 24 - 30 months now and are still writing without difficulty. For restoration purposes, the actual media is rarely the problem. Changes in encryption passwords (with a poorly documented history), files in use, and lost/orphaned files are the most common reasons for restoration failure.

  27. DVDs are a joke. by mosch · · Score: 4, Insightful

    An LTO Ultrium 3 tape holds 400GB uncompressed, and you can buy libraries that hold hundreds or thousands of these tapes (and dozens of drives).

    Disc to disc backup is gaining acceptance for some applications, but there are other places where the massive storage capacity of tape just can't be beat.

    The idea of DVD as a business-class backup medium is almost perfectly slashdottastic.

  28. Vista by Joe+The+Dragon · · Score: 3, Funny

    They may of been trying to do a clean install of vista and it some how took out the back up disk and the same time as the main disk. And they where using dell systems.

  29. inject + extract by mengel · · Score: 5, Informative
    Every night before backups add a file to partitions being backed up (like '.backuptst.txt') with the date in it.

    After you run the backup, memove then restore that file, make sure it has the current date in it.

    I've had that as a feature in my backup scripts for over 10 years...

    --
    - "History shows again and again how nature points out the folly of men" -- Blue Oyster Cult, 'Godzilla'
  30. $38 Billion is a big incentive for fraud by spun · · Score: 5, Interesting

    Ah, but we don't know the actual cost. Thirty eight billion is a lot of money. Suppose I wanted to skim some of that money, but I knew that the documentation existed in paper and computerized form. Perhaps I know someone in the records department who can shuffle some papers, but then the computerized records won't match. Oops, now those records are gone and we have no choice but to scan in the documents that I have changed, now everything agrees and there is no record of where that extra million or ten went.

    --
    - None can love freedom heartily, but good men; the rest love not freedom, but license. -- John Milton
    1. Re:$38 Billion is a big incentive for fraud by iocat · · Score: 4, Interesting
      They hired Dell and Microsoft to do the recover. Why not drivesavers or some other reputable firm that doesn't just run Norton but looks at the physical bits on the disc.

      Anyway, what DIDN'T shock me about this story is that after formatting the main disk, the tech immediately (and blissfully) formatted the backup as well. I've seen stuff like that happen like ten times. ("Oh, well, after I replaced the drive, I figured I should replace the backup tapes too, so we could have a fresh start, so I threw them out." or "I figured I should make a backup right away, so I over-wrote the good backup with the new, bad, data.") I don't want to blame the victim, but sometimes it's like the data wants to be destroyed at that point. My favorite was when someone added a second drive to an important source control server to do nightly drive to drive back-ups. Then, they stopped doing tape backups nightly and switched to weekly. Then, they forgot they disconnected a fan during the HDD installation (or it was accidently disconnected -- it remains a debated point), then the server fried itself and the drives. Then everyone lost a day of work rebuilding the source archive based on their local data. Good times.

      --

      Dude, I think I can see my house from here.

    2. Re:$38 Billion is a big incentive for fraud by Anonymous Coward · · Score: 5, Funny

      Dear deeply respected and trusted Sir,

        I trust by the grace of almighty god you are in good health this fine and beautiful day. I was a data entry clerk for the Alaska Department of Revenue, Prior to being fired, I secured access to a hidden fund worth $38,000,000,000 (THIRTY-EIGHT BILLION DOLLARS).

        If I ever tried to utilise this fund in my name, the funds would risk being confiscated by the government, so I would like you assistance to find a trustworth foreign assistant who can invest these funds.

        This proposal is 100% risk free, and I can offer you a 10% fee for your help.....

  31. Re:Data Recovery options? by dpilot · · Score: 5, Interesting

    About a month or 2 back, a slip of the fingers turned my root filesystem into a linux swap partition.

    Google was my friend. Shortly I learned more about backup superblocks, how to run "mkfs.ext3 -n" to do a dummy mkfs and find out where my backup superblocks are, and "fsck.ext3 -b nnn" to repair the filesystem using the backup superblock.

    I was back running in less than an hour, including google time. Repairing an accidental mkswap on top of ext3 is actually one of the easier things to fix.

    On the other hand, having a system and procedures that made it possible to kill regular and backup data that way, and storing unconfirmed tapes, is clearly not a good idea. Whenever I burn a CD/DVD, I take the few extra minutes and verify it right away. If the backup tape was only a few months old, odds are it was improperly written, as opposed to degraded. They should check their other backup tapes.

    --
    The living have better things to do than to continue hating the dead.
  32. Perspective by rlp · · Score: 4, Funny

    $38 billion is a lot of money. To put that in perspective, for $38 billion, Alaska could build over fifty bridges to nowhere.

    --
    [Insert pithy quote here]