Now that I??™ve spelled out the basic procedural structure for disaster recovery, I??™ll
explain the technical options available to you and how they relate to this basic structure.
CHAPTER 1 n WHAT IS DISASTER RECOVERY? 12
Making Database Backups
In terms of disaster recovery planning, creating a backup is the one step that is nonnegotiable
??”unless, of course, complete data loss is an option for you (and if so, you
probably bought the wrong book). Whether your database is 20MB or 20TB, this is the
first step in dealing with disaster recovery. Any discussion of disaster recovery planning
or restoring databases is incomplete unless you first have a solid understanding of the
backup process.
This chapter will focus primarily on Transact SQL (T-SQL) backup techniques and
features. (There are, of course, techniques other than T-SQL commands that you can use
to back up a database.) First, I??™ll briefly review the SQL Server storage model and database
recovery modes. Then, I??™ll look at options for the destination of the backup,
including backup devices. Finally, I??™ll explore the various backup commands, including
both their technical and practical usage.
Pages:
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73