The backups
must be able to fit on some sort of portable media (transmitting over the network is
not an option yet), and no discrete piece of the backup should be striped across multiple
physical devices.
Potential Approach
File and filegroup backups are almost certainly required here. No single backup file
should exceed the capacity of a single storage device. For small- to medium-sized databases
(less than 500GB), you can achieve this by aligning disk file sizes with your storage
medium. For the sake of example, let??™s say your tape drives can only handle a single
40GB file. If that??™s the case, each data file should not exceed 40GB.
For large databases (greater than 500GB), this scenario of flexible, portable storage
presents some real challenges. You could use an external hard disk device as your storage
medium and back up files together in 1TB chunks. Or, you could stick with the
single-file method on tape drives, but it would take a lot of tapes and a long time to
achieve a full backup.
CHAPTER 5 n CREATING A BACKUP/RECOVERY PLAN 133
nNote There are certainly hardware methods to deal with a large database.
Pages:
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271