For example, when performing a database upgrade for an application,
you usually have the opportunity to assess the likelihood and impact of a failure. You can
plan accordingly to mitigate risks. Since you know exactly when this process is going to
occur, you can, in a sense, ???predict??? a failure.
Here are some examples of process failure:
??? Service pack installation issues: While installing a service pack, a cryptic error message
occurs. From that point on, SQL Server doesn??™t start in normal mode.
??? Manual task not performed: At a satellite office, one of the formal jobs of the office
manager is to change the backup tape daily. The office manager goes on vacation
and forgets to instruct someone else to change the tapes. A failure occurs, prompting
a restore to two days ago. Unfortunately, there is only one tape, and it has been
continually overwritten each morning. Thus, the only backup you have is from that
same morning; you have nothing from two days previous.
??? Automated backup failure: A SQL Server backup job has been automated to run
every night at 4 a.m. Failure notifications go to a single DBA.
Pages:
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64