Continual review and testing is not just a go-through-the-motions task. It??™s your
opportunity to learn and enhance. Document what works and what doesn??™t. Document
restore times, and compare them to previous tests to extrapolate future restore times.
The possibilities for insights via testing are endless.
Enhancing Basic Scenarios
Once you??™ve chosen a basic plan, you should review it at a later date to see if there are
ways to further minimize risks and guarantee that the requirements are met. As you
might expect, the plan you??™ll end up needing in the real world won??™t fit one of the templates
neatly. Building a plan is a constant struggle between uptime, backup requirements,
and potential data loss. Politically, it can be a nightmare to get anyone to agree
on a single approach. (I??™ll discuss how to achieve political success in disaster recovery
in Chapter 12.)
You can speed up single database backups with the use of filegroup backups. File
and filegroup backups could include file differential backups to increase restore time.
If full-text search is used but not critical, removing its associated file from the backup
routine can speed things up significantly.
Pages:
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280