In Chapter 5, I??™ll discuss overall planning, and Chapter 13 will focus
on the types of business and interpersonal pressures that can make this job so difficult.
To successfully understand the entire process, you need to first break it down to its key
elements.
In this chapter, I??™ll focus on the technical aspects of a restore??”primarily, the T-SQL
RESTORE command. I??™ll examine ways to perform restores from within the GUI, but I??™ll
emphasize how to perform a restore using T-SQL. I??™ll cover the basic scenarios of full, differential,
and point-in-time restores, as well as a new SQL 2005 feature: page-level restore
(spoiler: this feature is not for the faint of heart). I??™ll describe issues surrounding the
restoration of system databases, and I??™ll offer a detailed look at the dreaded ???suspect???
43
C H A P T E R 3
database state. As always, I??™ll conclude by showing you how this all fits in with general
disaster recovery categories, and I??™ll discuss major caveats and recommendations.
Restore vs. Recovery
It??™s important to understand the difference between a restore and the process of recovery.
Pages:
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122