Over the years, I??™ve been in this situation dozens, if not hundreds, of times. Looking
back, what jumps out at me is how differently everyone views SQL Server disaster recovery.
Here are some of the various interpretations that I??™ve encountered:
1
C H A P T E R 1
??? Making sure your data is backed up
??? Having a backup/recovery scheme
??? Having a documented backup/recovery scheme
??? Having a documented backup/recovery scheme with directions so thorough that a
ten-year-old could follow them
??? Off-site data storage
??? Planning and documenting all procedures to respond to any type of outage
As this list implies, some view disaster recovery somewhat simplistically, while others
see it as a massive project. All interpretations can be valid, but bear in mind that one
interpretation might encompass too much, while another interpretation might leave
important aspects out.
For the purposes of this book, I??™ll define disaster recovery as encompassing the following:
??? The process involved in returning a downed instance or server to a functioning
state
??? The process of restoring a damaged database to a functioning state
??? The process of restoring lost data
??? Mitigation of risks for downtime or loss of data
??? Identification of cost, either due to mitigation steps taken or downtime/data loss
??? Some level of planning and documenting these processes and mitigation steps
??? Consultation with the business owner of the data
Consulting with the business owner of the data is a critical step.
Pages:
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53