Chapter 5 shifts from a more technical discussion to the practical activity of creating
a backup/recovery plan. Approaching backup without considering what the
restore requirements might be (such as how much downtime and potential data
loss is acceptable) is irresponsible. Backup and restore always go hand in hand,
particularly when planning.
Chapter 6 begins the discussion of mitigation techniques, starting with log shipping.
Up to this point in the book, I??™ve talked about how to react to disasters with backup/
recovery. You can use log shipping to create a standby database to minimize the
impact of a number of disasters, including catastrophic environmental issues.
Chapter 7 continues with a technical discussion of database clustering, another
mitigation technique. Also used to minimize the impact of a disaster, database
clustering focuses specifically on server failure. Although limited in its usefulness,
database clustering should be considered in any disaster recovery plan.
Chapter 8 focuses on database mirroring, which is basically a combination of log
shipping and database clustering.
Pages:
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49