Knowing how to perform a backup/restore of a SQL Server database does not
impart instructions on what to do with that knowledge. How often should a database
be backed up? How about the transaction log? These questions differ depending on your
specific business environment. Perhaps a single nightly backup is sufficient. Or perhaps
a nightly backup is impossible due to the size of the database. Restore requirements
might focus on minimizing downtime, or they might stress as close to zero data loss as
possible. Knowing the what involved with any technology is the key to being successful
as a technology professional.
Thus, I will endeavor to present you with less how and more what in this book.
In the coming pages, I??™ll present you with my concept of what disaster recovery is, the
tools available to SQL Server to deal with disaster recovery, and my process for disaster
recovery planning and dealing with disaster scenarios. This book is heavy on my point
of view and lighter on the technical specifics. If you??™re looking for technical specifics,
Books Online (http://msdn2.microsoft.
Pages:
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45