Wednesday, August 22, 2007

An EUL horror story

EUL backups - now there's a novel concept. Let me tell you a story.

Just over a year ago I consulted to a large organization and created a new EUL with a couple of business areas. It took three weeks to complete. On the Friday when I was leaving I migrated the whole lot from Dev to Prod and left.

About 11am on Monday morning I received a call that went something like this: Michael, hello, how are you? Ummm - Discoverer deleted itself from production. Don't you find that odd? Why does it do that?

Well you can't kid a kidder. Because I know the tool so well I said - it cannot just delete itself - either the owner or someone who knows the EUL owner's password must have logged in and told Discoverer to delete the EUL.

No admissions of guilt were offered - naturally. I mean - would you own up to having deleted your company's production reporting system on the same day that it went live? Perhaps booking a one-way ticket to Australia (sorry oz - but I am English) would be in order.

No problem - I said - go to your Prod backup and restore your EUL schema. You'll soon be back up and running.

Ah - they said - here's the second problem - we forgot to put the EUL schema into the backup routine.

Hmm - I said - in that case all you have to do is go to your Dev instance, export the EUL and then import it into Prod.

Ah - they said - here's the third problem - we refreshed Dev from Prod on Sunday afternoon and it also does not contain an EUL.

Oops - I said - when do you want me to come back?

Let us think about it - they said - and we'll call you back.

They did call me back and I informed them that before I left on Friday I had taken a backup myself of the EUL in Dev and told them where it was on their server.

Phew - they said - thank you, thank you. Oh and by the way the DBA admitted to having dropped the EUL schema on Friday evening as he thought it was a user messing about!

I recount this story as a warning to everyone else - please make sure your EUL schema is included in your backups. A good administrator should also take periodic exports of the EUL - just in case!

Anyone else got a similar horror story - hopefully with a happy ending?

By the way - I'm in Boston this week and I can't find a decent English cup of tea anywhere. In years gone by we would have gone to war over that. Oh - we did - and we lost. Methinks I'd better keep a low profile.


Anonymous said...

That's damn funny.!!!
Hmmm lemme guess your client in Aus... Is that 'ResMed' ?.

Anonymous said...

Hahahah! Excellent post. If you are ever in Charleston, SC and want some good English tea, I suggest the Thoroughbred Club at Charleston Place hotel. Don't worry,they will treat you right.