Using filegroups to separate data files and indexes can speed the backup of the
actual data. It won??™t necessarily improve restore times, but you can arrange filegroups
in very creative ways to improve the backup or restore process.
The partial backup/piecemeal restore routine, with strategically configured filegroups,
allows you to bring the database online as each piece is being restored.
There are a number of creative ways to improve on these basic scenarios. Always
keep this one thing in mind: start with a simple plan, and then improve it. Never look
for the final solution in the first step.
CHAPTER 5 n CREATING A BACKUP/RECOVERY PLAN 138
Caveats and Recommendations
This chapter has covered in detail the essential aspects of creating a sound plan for
backup and recovery of a database. As you might expect, the planning process is fraught
with pitfalls. Keep the following in mind as you plan for your own databases, and you??™ll
likely avoid those pitfalls:
??? Be conservative: One of the biggest mistakes you can make when designing a
backup/recovery plan is to set expectations too high.
Pages:
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281