m.
??? Log backups every 15-30 minutes
Something this simple could become more complex if a full backup were available
only weekly or monthly.
CHAPTER 5 n CREATING A BACKUP/RECOVERY PLAN 125
nNote I??™m leaving differential backups out of this scenario, because as the day, week, or month progresses,
the size of a differential backup, as well as the time required to perform it, will increase steadily.
Remember your primary goal here is to minimize backup time, not restore time.
For medium to large databases (greater than 50GB), a single full backup is almost
impossible. At this point, filegroup and file-based backups are essential. This implies that
you??™re using multiple files and, hopefully, multiple filegroups. It??™s hard to imagine having
databases in the terabyte size where filegroups aren??™t involved, but believe it or not, I??™ve
seen it.
The advantage to using filegroups is twofold. First, a filegroup backup essentially
acts as a shortcut to backing up the individual files it contains (less backup code to
write). Second, it allows you to be selective in what you back up.
Pages:
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256