The DBA has been
out sick for four days when a failure occurs and a restore is required. Nobody was
aware of the problem, because the one person who received the failure notification
e-mails had been out sick and not checking his e-mail. A system administrator
goes to the server to restore the SQL databases only to discover that the
automated job has failed the past three days.
User
User error is the most difficult category to deal with. User errors are unpredictable and
potentially devastating in their impact. Users can come up with a seemingly unending
number of creative ways to cause havoc. Here are a few examples:
??? ???Where is the WHERE????: Most of us are guilty of this at one time or another. We forget
to put a WHERE clause on a DELETE or UPDATE statement. In one particular case, an ad
hoc change was required to the database??”three child records needed to be associated
with a different parent record. Needless to say, the change occurred for every
record in the database.
??? ???I didn??™t delete that???: A data entry clerk accidentally deletes the largest customer
from the database.
Pages:
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65