This sidebar, however, is the extent of my discussion about these tools. Using these types of tools
is perfectly valid to help address SQL Server disaster recovery. However, they don??™t address the base
issues of disaster recovery; instead, they enhance solutions that are already in place. When approaching
disaster recovery, always assume the worst-case scenario. That includes assuming that the native
SQL Server tools are the only option available to you. You can always use third-party tools to enhance
your disaster recovery process, but you should never consider them as a starting point.
CHAPTER 2 n MAKING DATABASE BACKUPS 30
Error Checking
The backup process can perform verification of the data as it is being backed up, either
checking for torn pages or validating checksums. You must enable whichever option you
desire at the database level, as shown in Figure 2-6 for checksum validation.
Figure 2-6. Page Verify options allow you to choose between no verification, checksum
validation, and torn-page detection.
Torn-page detection simply checks each data page to see if a write process completed
in its entirety.
Pages:
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104