Stories
Slash Boxes
Comments

News for nerds, stuff that matters

Slashdot Log In

Log In

Create Account  |  Retrieve Password

So You've Lost a $38 Billion File

Posted by Zonk on Tue Mar 20, 2007 09:58 AM
from the makes-you-feel-better-about-yourself dept.
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."
+ -
story
This discussion has been archived. No new comments can be posted.
The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
 Full
 Abbreviated
 Hidden
More
Loading... please wait.
  • Time for... (Score:5, Funny)

    by Short Circuit (52384) * <mikemol@gmail.com> on Tuesday March 20 2007, @09:59AM (#18414365) Homepage Journal
    Seppuku [wikipedia.org]?
    • by Rakshasa Taisab (244699) on Tuesday March 20 2007, @10:26AM (#18414993) Homepage
      Thanks for alleviating my ignorance [wikipedia.org].
      • by Anonymous Coward on Tuesday March 20 2007, @10:42AM (#18415293)
        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.
        • Re:Time for... (Score:5, Insightful)

          by jadavis (473492) on Tuesday March 20 2007, @11:10AM (#18415899)
          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.
          • Re:Time for... (Score:5, Interesting)

            by nelsonal (549144) on Tuesday March 20 2007, @11:35AM (#18416373) Journal
            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...
          • 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.
            • by Anonymous Coward on Tuesday March 20 2007, @12:29PM (#18417363)
              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.....

              • by iocat (572367) on Tuesday March 20 2007, @12:27PM (#18417327) Journal
                They hired Dell and Microsoft to do the recover. Why not drivesavers [drivesavers.com] 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.

      • by dpilot (134227) on Tuesday March 20 2007, @11:46AM (#18416601) Homepage Journal
        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.
  • Redo the work? (Score:5, Insightful)

    by Anonymous Coward on Tuesday March 20 2007, @10:02AM (#18414433)
    For that kind of money, I'd probably just send the HD to data recovery specialists.
    • Re:Redo the work? (Score:5, Insightful)

      by omeomi (675045) on Tuesday March 20 2007, @10:08AM (#18414587) Homepage
      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 ;-)
        • Re:Redo the work? (Score:4, Interesting)

          by sumdumass (711423) on Tuesday March 20 2007, @11:34AM (#18416355) Journal
          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.
  • The Senator (Score:3, Funny)

    by jeevesbond (1066726) on Tuesday March 20 2007, @10:03AM (#18414437) Homepage

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

    • They DID send it in an internet, but we were clogging up the tubes with "youtubes" and "myspaces" that it didn't reach them until AFTER they finished copying it!
  • And this is why... (Score:4, Interesting)

    by bobetov (448774) on Tuesday March 20 2007, @10:03AM (#18414439) Homepage
    ...print will never be dead.
    • by evilviper (135110) on Tuesday March 20 2007, @10:34AM (#18415127) Journal

      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.)
  • $38 billion? (Score:5, Insightful)

    by pipatron (966506) <pipatron@gmail.com> on Tuesday March 20 2007, @10:03AM (#18414441) Homepage
    How did they figure these files were worth $38 billion when it only cost $200000 to create them from scratch?
  • I'll do it! (Score:5, Funny)

    by mwvdlee (775178) on Tuesday March 20 2007, @10:06AM (#18414509) Homepage
    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.
  • maxtor? (Score:5, Funny)

    by ElephanTS (624421) on Tuesday March 20 2007, @10:06AM (#18414525)
    As their IT consultant I stand by my use of Maxtor drives.
  • by Maxo-Texas (864189) on Tuesday March 20 2007, @10:09AM (#18414621)
    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.
  • by condour75 (452029) on Tuesday March 20 2007, @10:11AM (#18414669) Homepage
    And it's not in the recycle bin? Ok, let's not panic. Click start, go to find, choose files and folders...
  • Damn! (Score:5, Insightful)

    by Penguinisto (415985) on Tuesday March 20 2007, @10:12AM (#18414681) Journal
    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

  • Alaskan Pipeline (Score:3, Insightful)

    by Doc Ruby (173196) on Tuesday March 20 2007, @10:13AM (#18414723) Homepage Journal
    I bet it cost a lot less than $200K to bribe the government officials (probably with a few bottles of wine) not to check whether they were protecting their $38B investment with more than $45K worth of IT staff.
  • Data recovery? (Score:5, Interesting)

    by evilviper (135110) on Tuesday March 20 2007, @10:16AM (#18414777) Journal
    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.
    • Re:Data recovery? (Score:5, Insightful)

      by mwvdlee (775178) on Tuesday March 20 2007, @10:29AM (#18415061) Homepage
      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.
  • Not to bad (Score:4, Informative)

    by geekoid (135745) <dadinportland AT yahoo DOT com> on Tuesday March 20 2007, @10:17AM (#18414797) Homepage Journal
    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.

  • by 140Mandak262Jamuna (970587) on Tuesday March 20 2007, @10:24AM (#18414957) Journal
    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.

  • by Unique2 (325687) on Tuesday March 20 2007, @10:39AM (#18415215)
    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.
    • by AK Marc (707885) on Tuesday March 20 2007, @12:01PM (#18416849)
      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.
  • Vista (Score:4, Funny)

    by Joe The Dragon (967727) on Tuesday March 20 2007, @11:03AM (#18415761)
    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.
  • Perspective (Score:5, Funny)

    by rlp (11898) on Tuesday March 20 2007, @12:06PM (#18416947)
    $38 billion is a lot of money. To put that in perspective, for $38 billion, Alaska could build over fifty bridges to nowhere.
    • Re:Tapes? (Score:5, Informative)

      by MindStalker (22827) <jlarsen@@@fsu...edu> on Tuesday March 20 2007, @10:03AM (#18414453) Journal
      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.
        • Re:Tapes? (Score:5, Interesting)

          by Philosinfinity (726949) on Tuesday March 20 2007, @10:50AM (#18415481)
          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.
    • Re:Tapes? (Score:4, Insightful)

      by teflaime (738532) on Tuesday March 20 2007, @10:05AM (#18414493)
      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.
      • Re:Tapes? (Score:5, Insightful)

        by Itninja (937614) on Tuesday March 20 2007, @10:13AM (#18414721) Homepage
        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).
    • Re:Tapes? (Score:5, Informative)

      by greginnj (891863) on Tuesday March 20 2007, @10:07AM (#18414549) Homepage Journal
      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.
      • Re:Tapes? (Score:5, Informative)

        by Sobrique (543255) on Tuesday March 20 2007, @10:46AM (#18415373) Homepage
        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.

    • Re: (Score:3, Insightful)

      Tape works great if you are willing to spend big bucks for top-class hardware. Unfortunately, most people try to get by with the cheap stuff, which is very unreliable. Try to explain to a manager why you need a $50K tape system to backup a $10K server. Computers have gotten very cheap, high-quality tape transports haven't.
    • Re:Tapes? (Score:5, Insightful)

      by daeg (828071) on Tuesday March 20 2007, @10:11AM (#18414675)
      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?
    • DVDs are a joke. (Score:5, Insightful)

      by mosch (204) on Tuesday March 20 2007, @10:51AM (#18415485) Homepage
      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.
    • Re:Actual Cost?? (Score:4, Informative)

      by ClickOnThis (137803) on Tuesday March 20 2007, @10:28AM (#18415043) Journal
      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.
    • by saigon_from_europe (741782) on Tuesday March 20 2007, @10:32AM (#18415119)
      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