Cascading deletes had been turned on, so every order that customer
made was deleted.
CHAPTER 1 n WHAT IS DISASTER RECOVERY? 8
??? Too much power in the wrong hands:My favorite disaster of all time happened to
me personally. I was working as a DBA at a small consulting company with only
one SQL Server. A colleague came into my office with the following speech: ???Hey,
I was going to upload those new files we got from that client, and there wasn??™t
enough room, so I tried to delete something something dot something, but it said
it was in use, so I disabled a service and then I was able to delete it. Now I can??™t
connect to the SQL Server. Did you make some changes???? Enough said.
Predictability, Probability, and Impact
I??™m sure many of you are reading through these examples and thinking ???This one is easy
to remedy??? or ???Well, if you designed the application properly. . . .??? If you??™re thinking that,
fantastic! Problem solvers unite! I, however, approach things a bit more cynically. I look
at each example and think about what other things might go wrong or roadblocks to
implementing some sort of mitigation solution.
Pages:
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66