You should first explore other techniques for improving performance, one being
file/filegroup backups, which I??™ll discuss in Chapter 4.
??? Don??™t fear Simple Recovery mode: Some say that any production database should
be in Full or Bulk-Logged Recovery mode. I don??™t necessarily agree with that. As
you??™ll see in later chapters, if the business unit truly understands the implications
of Simple Recovery mode (meaning the amount of data lost) and is comfortable
with those implications, why put yourself through the trouble of managing transaction
log backups?
??? Manage backup devices and sets: While it may be tempting to store more than one
backup in a single device or file, make sure that you manage how many copies you
keep. It can be easy to append too many backups to one file and fill the hard disk
or tape on which it is stored.
??? Follow a naming convention: It doesn??™t really matter what technique you use, but
stick to a naming convention. One that incorporates the database name, the type
of backup, and the time of creation is usually best.
CHAPTER 2 n MAKING DATABASE BACKUPS 40
Summary
As you??™ve seen, there are a number of different methods to back up a database, each with
its own benefits and drawbacks.
Pages:
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119