??? Media: Using checksum validation at least notifies you of the possibility of media
failure. Mirrored backups also minimize risk so that no single media device disrupts
your recovery capabilities.
??? Process: Copy-only backups play a role in dealing with process error; however, their
role in such a scenario is only to speed the restoration effort. An effective log
backup scheme is still the key to protection against process failure.
??? User: As with process failures, copy-only backups can have an impact from a performance
perspective (assuming differential backups are used). Again, the key to
mitigating user failure is proper log backups.
Caveats and Recommendations
I??™ve learned a lot about backup and recovery in my career. The following list summarizes
some lessons learned and gives recommendations to help guide you in constructing a
disaster recovery plan for your databases:
CHAPTER 2 n MAKING DATABASE BACKUPS 39
??? Time is the ultimate enemy: No matter what type of backup and what process you
used, you??™re dealing with magnetic media and mechanical devices such as hard
disks and tape drives.
Pages:
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117