SEARCH
0-9 A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
Prev | Current Page 199 | Next

James Luetkehoelter

"Pro SQL Server Disaster Recovery"


A system??™s business owners and IT staff must define both BRPs and mitigation techniques
cooperatively. Business owners lack the technical knowledge of how to achieve
the desired level of disaster recovery, while IT staff lack the appropriate business knowledge
to determine an appropriate level of disaster recovery.
The misconceptions that a BRP is equivalent to a disaster recovery plan or that IT
determines what BRP is used make for the most common and costly mistakes. In this
chapter, I??™ll explain exactly what a backup/recovery plan entails, who is involved, and
the constraints they face. Everyone wants to have no downtime and no data loss, but
even approaching that level of protection can be a costly undertaking. I??™ll also look at
the most common BRP scenarios.
Components of a Backup/Recovery Plan
On the surface, a BRP is deceptively simple to create because it has few high-level components.
At a bare minimum, a BRP is composed of the following items:
??? Documented data-protection requirements
??? A documented daily/weekly/monthly backup scheme
??? A documented restore process
??? A documented testing and reevaluation plan
Seems straightforward, doesn??™t it? Think again.


Pages:
187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211