Disaster recovery is a daily job duty of a database administrator.
Chapter 2 focuses on truly understanding the database backup process. There are
many misleading aspects to the backup process, so without a thorough understanding
of just how a backup works, you run the risk of building the foundation of your
disaster recovery plan on crumbling bricks.
Chapter 3 builds on Chapter 2 by exploring how to use database backups to restore
a database. As with the backup process, you can often be misled while performing a
restore. If you aren??™t familiar with the pitfalls ahead of you, a restore process could
take much longer than you anticipated (and much longer than your manager wants).
nINTRODUCTION xxii
Chapter 4 explores more complicated backup and recovery techniques using filegroups.
As a database grows in size and functionality, it may be necessary to break
up the backup process into smaller steps; a full nightly backup just may not be
physically feasible. From a restore perspective, you may have data you??™d like available
before the entire database is restored. Filegroups are the key to both highly
customized backups and piecemeal restores.
Pages:
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48