BOFH: Recover a database from five years ago? It's as easy as flicking a switch
- Reference: 1760085734
- News link: https://www.theregister.co.uk/2025/10/10/bofh_2025_episode_19/
- Source link:
Belts are tightening everywhere but the boardroom.
It therefore comes as a surprise when the Boss rolls hastily into Mission Control with an urgent request for a large chunk of weekend work.
[1]
"We need to recover the Financials Database," he says.
[2]
[3]
"How far back?" I ask. "We could probably load a cloud snapshot in half an hour if it's not too far."
"I'll check," he says, wandering off.
[4]
About ten minutes later, he's back with the Heads of both Beancounting and HR...
"We need you to recover the database from, uh... five years ago," the Head Beancounter says.
"Five years ago!" the PFY gasps. "We're not even using the same accounting system!"
[5]
"Yes. Well. We'll still need to get that recovery done," the Head of HR says.
"But we'd need to run up all of the old system," I gasp. "We'd have to get some old hardware."
"Don't you have some sort of backup copy of the old financials?" he asks.
"Sure, but it needs to run on a machine, and we disposed of the hardware when we migrated to the Cloud."
"But you could do it?"
"Sure. We'll need to source some fairly similar second-hand kit as it's a full system snapshot – OS and all – and we might need to procure some questionable licenses to run the software."
"We need to do it," the Head Beancounter sighs.
...
"OK, I... guess I can ask around to see if anyone has some," I say, "but I doubt it'll be cheap."
The standout observations from this conversation are: (a) the presence of the Head of HR, (b) the lack of concern about both cost and dodgy licenses, and (c) this really is quite urgent – for some reason.
There's palpable relief from the two senior managers when I tell them that we've been able to source some kit from a company specializing in older computer hardware – and that they'll lease it to us instead of us having to buy it.
"How long will it take to get up and running?" they ask, almost in unison.
"If we start now, we'll have everything running by... Monday morning?" I suggest. "The good news is that we can probably use the original license product activation keys if we set the clock back to pre-migration date."
"Oh, we'll need to do that," the Head Beancounter says unhappily. "But will it take all weekend?"
"Well, we do have to run up an isolated network, then a pair of domain controllers running an old DC snapshot, then recover the database machine, then create a VM with the client-side software."
"It's not as easy as flicking a switch," the PFY adds.
"And the equipment people want the money up front before they deliver the hardware. They can bring it later tonight, though."
The Head Beancounter takes the account information off to make a rapid payment – which is a move that contravenes the Company's financials policy in a number of ways. But this is important.
"We could pull an all-nighter, I guess," I tell the Head of HR. "Only we'll need..."
"Time and a half?" the Head of HR says dryly.
[6]BOFH : HR discovers the limits of vertical mobility
[7]BOFH : These office thefts really take the biscuit
[8]BOFH : HR plays checkers, IT plays 5D chess
[9]BOFH : Deepfake or just an idiot? We'll need an audit to confirm
"Time and a half for the first three hours," I reply. "But as you know, it's double time for all subsequent hours, a meal break for dinner, a meal allowance for dinner, a meal break for breakfast, a meal allowance for breakfast, etc. If we don't get an eight-hour break every 16 hours we're entitled to a personal wellbeing allowance, which compounds every 24 hours without a break..."
"Then you should work in shifts."
"That's a great idea, though again – as you know – Company policy mandates that people working in dangerous areas are not permitted to work alone for periods longer than half an hour. And I think the injury register would prove that the server room is a dangerous area. Not nearly as dangerous as the stairwell or our office window, but considerably more dangerous than most of the rest of the building..."
A quarter of an hour of wrangling later, we've reached a deal that is agreeable to both parties.
A further ten minutes of discussion reveals the nub of the crisis. It turns out that the Financials Database does NOT contain the secret of world peace, the combination to the locking system of Pandora's Box, nor the magic keystrokes to get you to level 25 of Rogue with masses of gold and armor. What it DOES contain, however, is information on which senior managers may have crossed the fine line between tax avoidance and tax evasion.
"And if you can get it up before Monday, that would be great," the Head of HR says. "We've got someone who wants to come in and, uh, modify some, uh, errors."
"We can but try," I say. "But it might require some form of bonus. It's not as simple as flicking a switch..."
...
Only it is as easy as flicking a switch – the switch at the bottom of a rack of gear that we didn't get around to recycling when we moved to the Cloud.
Still, we will probably have to set those clocks back...
[10]BOFH: Previous episodes on The Register
[11]The Compleat BOFH Archives 95-99
Get our [12]Tech Resources
[1] https://pubads.g.doubleclick.net/gampad/jump?co=1&iu=/6978/reg_offbeat/bofh&sz=300x50%7C300x100%7C300x250%7C300x251%7C300x252%7C300x600%7C300x601&tile=2&c=2aOjZNwZweDsBpC25eRKVtwAAAEQ&t=ct%3Dns%26unitnum%3D2%26raptor%3Dcondor%26pos%3Dtop%26test%3D0
[2] https://pubads.g.doubleclick.net/gampad/jump?co=1&iu=/6978/reg_offbeat/bofh&sz=300x50%7C300x100%7C300x250%7C300x251%7C300x252%7C300x600%7C300x601&tile=4&c=44aOjZNwZweDsBpC25eRKVtwAAAEQ&t=ct%3Dns%26unitnum%3D4%26raptor%3Dfalcon%26pos%3Dmid%26test%3D0
[3] https://pubads.g.doubleclick.net/gampad/jump?co=1&iu=/6978/reg_offbeat/bofh&sz=300x50%7C300x100%7C300x250%7C300x251%7C300x252%7C300x600%7C300x601&tile=3&c=33aOjZNwZweDsBpC25eRKVtwAAAEQ&t=ct%3Dns%26unitnum%3D3%26raptor%3Deagle%26pos%3Dmid%26test%3D0
[4] https://pubads.g.doubleclick.net/gampad/jump?co=1&iu=/6978/reg_offbeat/bofh&sz=300x50%7C300x100%7C300x250%7C300x251%7C300x252%7C300x600%7C300x601&tile=4&c=44aOjZNwZweDsBpC25eRKVtwAAAEQ&t=ct%3Dns%26unitnum%3D4%26raptor%3Dfalcon%26pos%3Dmid%26test%3D0
[5] https://pubads.g.doubleclick.net/gampad/jump?co=1&iu=/6978/reg_offbeat/bofh&sz=300x50%7C300x100%7C300x250%7C300x251%7C300x252%7C300x600%7C300x601&tile=3&c=33aOjZNwZweDsBpC25eRKVtwAAAEQ&t=ct%3Dns%26unitnum%3D3%26raptor%3Deagle%26pos%3Dmid%26test%3D0
[6] https://www.theregister.com/2025/09/19/bofh_2025_episode_18/
[7] https://www.theregister.com/2025/09/12/bofh_2025_episode_17/
[8] https://www.theregister.com/2025/08/22/bofh_2025_episode_16/
[9] https://www.theregister.com/2025/08/01/bofh_2025_episode_15/
[10] https://www.theregister.com/data_centre/bofh/
[11] http://www.bofharchive.com/
[12] https://whitepapers.theregister.com/
Saved by apathy?
Who hasn't been saved by something they hadn't got round to throwing away yet?
Re: Saved by apathy?
At work this got learned the hard way a year or two back.
A lot of hardware programmers for our kit dated from the Windows XP or Windows 7 era.
Most of them had software that ran okay on W10 (who knows about W11 but we'll cross that bridge when we get to it), but one hardware programmer for a component that no-one had needed to touch for a good half decade suddenly needed upgrades for regulatory stuff.
Turned out the software would absolutely not run on W10.
IT had decided to have a clearout at some point, and had binned their W7 era install media and backups. Cue much scraping around trying to find a W7 iso from a source that our infosec guy was happy with....
5 year old database?
I can dream of such a young database. I'm supporting databases that are over 20 years old running on an OS that was first released in 2000.
At least the hardware is new though. The beauty of virtualisation
Re: 5 year old database?
I hear you. I've recently been asked to recover old BTRIEVE records that last saw the light of day on a Novell Netware 3.11 server.
(Fortunately it didn't require resurrecting NW3.11 from the grave, though.)
Re: 5 year old database?
I recently had a request for some data going back to before 2008 (when we migrated to the current ERP system). Unfortunately we don't have the software, a machine capable of running it or anyone who knows how to actually use it! I do have the data locked away and know someone who might have been able to help had it been critical but it was only asking about some material we'd once supplied to a customer and I doubt any info would have been relevant now.
Re: 5 year old database?
Must be an age thing, but 2000 doesn't immediately sound all that old,,,
Or just use the backup data?
The question perhaps is just what information was actually needed? If a system like say Horizon was built properly in the first case, then any competent accountant could have verified just what amounts of money had been paid and to whom? And all of that data would have been backed up annually as part of the annual accounts? It should not need to be able to run old software to access the raw data at all and certainly a migration SHOULD have included access to the previous years raw data?
But don't tell the boss that ...
Re: Or just use the backup data?
While it is possible to extract useful data from a basic SQL dump, but it takes a lot of guessing as to how the original designers spread information across different tables. Especially as many accounting apps were often first implemented thirty plus years ago, and have been sporadically upgraded by different teams, with completely different ideas about database design. Sometimes it's easier to resurrect the original software.
(I'm remembering one particualr product I dealt with that still had a TELEX field in their customer entries. The first ten years or so of data were in one set of tables, and then subsequent data was stored in a completely different layout, because presumably there had been some kind of upgrade. No documentation of course.)
"Belts are tightening everywhere but the boardroom."
That would be funny if it weren's so very, very true.
Hmm we have some kit that is still sitting sealed in boxes and it has gone end of support so has been there at least 10 years and as for stuff in comms rooms that should have been removed…..
Old kit disposal?
I've heard of that ...
For some reason there's still an old Compaq 80486 DX @ 60 MHz with 8 MB RAM and an ancient tape drive, and a hand-soldered experimental video camera exposure control ISA-Bus board I designed during my PhD work. You never know when that old tape drive might come in handy.
> Still, we will probably have to set those clocks back...
Hopefully the BOFH won't get over-zealous and set the time and a half back