|
Free ebooks
 Free database ebooks SQL Pro SQL Server Disaster Recovery - The Expert's Voice in SQL Server
|
 Chapter 1 introduces my interpretation of disaster recovery. Although short, this chapter is extremely important, because it spells out the premises I work with throughout the rest of the ebook. Disaster recovery is not simply a backup/restore process, it is not simply high-availability techniques, and it is not a project to be completed. 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. 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. Chapter 5 shifts from a more technical discussion to the practical activity of creating a backup/recovery plan. Approaching backup without considering what the restore requirements might be is irresponsible. Backup and restore always go hand in hand, particularly when planning. Chapter 6 begins the discussion of mitigation techniques, starting with log shipping. Up to this point in the book, I’ve talked about how to react to disasters with backup/recovery. Chapter 7 continues with a technical discussion of database clustering, another mitigation technique. Also used to minimize the impact of a disaster, database clustering focuses specifically on server failure. Although limited in its usefulness, database clustering should be considered in any disaster recovery plan. Chapter 8 focuses on database mirroring, which is basically a combination of log shipping and database clustering. By keeping an up-to-date standby database at a remote location, database mirroring can protect against a wide variety of possible disasters, from hardware issues to an actual tornado. Chapter 9 briefly discusses database snapshots. An often-overlooked aspect of disaster recovery is user error, which is unpredictable and potentially devastating. Chapter 10 combines a technical discussion of some of the hardware implications you may face with practical approaches you can use to work through those hardware issues. Chapter 11 discusses how to approach disaster recovery planning. This completely nontechnical chapter discusses how to combine backup/recovery planning with disaster mitigation techniques to prepare a thorough disaster recovery plan. Chapter 12 discusses the nontechnical roadblocks you may face when undertaking disaster recovery planning—namely, working with others. The human variable is usually the biggest issue when it comes to disaster recovery planning. Download free ebooks of SQL:Pro SQL Server Disaster Recovery
|
