I established that, for the purposes of this book, disaster
recovery encompasses reducing the likelihood of the disaster and returning the system to
a functioning state. Simply put, disaster recovery is mitigation and response.
SQL Server has long had technologies in place to handle mitigation and response.
SQL Server 2005 includes new technologies and improvements that have completely
changed the way we should think about disaster recovery. Having a backup and recovery
plan can and should be augmented by other techniques. Given the increasing size of the
average database, a straightforward full backup is becoming an untenable technique on
which to rely.
Mitigation Technologies
Certain technologies center only on reducing the likelihood or impact of any particular
disaster. These I classify as mitigation technologies. Here are some examples:
CHAPTER 1 n WHAT IS DISASTER RECOVERY? 10
??? Clustering: A longtime feature in SQL Server, clustering allows you to set up additional
failover servers to take control of the database should the primary server fail.
??? Log shipping: A technique that has been used manually in the past, log shipping is
the process of copying log backups and moving them to a standby server that continually
restores them.
Pages:
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69