Disaster 1: The Great Database Debacle

The first disaster in the Database Disasters series: the Great Database Debacle.

It all started when our lead database administrator, Bob, decided to "reorganize" the database by moving all the tables to alphabetical order.

As you can probably guess, this was not a good idea.

Read about the Consequences

Move on to Disaster 2

Cause of the Disaster

The cause of the Great Database Debacle was a combination of user error (Bob) and the fact that nobody told him what the word "reorganize" actually means.

SELECT * FROM table WHERE name = 'Bob' AND position = 'Database Admin'

UPDATE table SET location = 'Alphabetical Order' WHERE table_name = 'Bob''s Table'

DELETE FROM table WHERE name = 'Sensible Decision Making'

Read about the Recovery

Disaster Stats