Backup & Recovery: Inexpensive Backup Solutions for Open Systems

When I picked up this text, I kind of expected it to be a bit sparse in some areas. After all, it's an ambitious book. With individual chapters on every database from DB2, Oracle and Sybase to MySQL, Postgres and SQL Server. In addition he also covers OS backups on Solaris, Linux, AIX, HP-UX, and Mac OS X. Preston though, succeeds, and succeeds with flying colors. What I was struck by most of all, after reading it, is his clear breadth of knowledge in the subject of backups. Each of the different databases alone do things differently, and have a lot of different concepts, and vernacular to describe it. He starts the book with the basics, what backing up is all about, why you do it, and what to consider. What are you backing up and why? How often, and using what method? Roll-your-own solution scripting with unix utils like dd, cpio, or tar, go with an open source solution such as Amanda, Bacula, or BackupPC, or consider various commercial solutions. And lastly, don't forget testing and verifying your backups. Preston doesn't let anything through the cracks. I have worked on Unix for years and years, but my sweet spot is working with databases. So I read the chapters on Oracle and MySQL very carefully. In both cases I learned something new. For instance during an Oracle hotbackup, did you know that changes to datafiles are *NOT* frozen. Learn how Oracle reconstructs your data using a hotbackup, by reading his careful discussion on the topic. Databases are not simple beasts, and the backup considerations are not trivial. Nonetheless, I would recommend this book as your reference for doing database backups on any of these platforms. Lastly I like the writing style. He calls it "champagne backup on a beer budget". Good stuff. You'll find this book interesting to read, full of detail when you need it and pointed when necessary. Go pickup a copy.

In the realm of important things in the world of computers are good backups and equally important is the ability to properly restore those backups. My initial attraction to this book had to do with it being tapered toward open system solutions. I am an avid user of Linux and open-source software, so I was interesting in learning about the free tools that the author writes about. The author starts out by discussing "The Philosophy of Backup" which covers why backups are so important and how you to find a solution that both meets your needs and your budget. Chapter two goes over what to backup, how often and at what levels. It also discussed what types of disaster to be prepared for, automation, storage, testing and things to look out for on various OS's. Chapters 3-7 cover open-source backup utilities. In chapter three the author discusses and provides examples of how to use basic utilities such as dump, cpio, tar and dd for Unix systems, ntbackup and System Restore for the Window's crowd, ditto for Mac, and the GNU versions of tar, cpio, and rsync. Chapter's 4-6 discuss Amanda, BackupPC and Bacula. Chapter seven digs into near-continuous data protection and how the open-source community is achieving this, and what tools to use. By chapter 8 and 9 the author is discussing commercial backup solutions. This section is different from the last in that it doesn't really discuss specific tools and how to use them, but rather it discusses the features of commercial products. This section also covers the various types of backup hardware on the market in an effort to help the reader decide what media best meets their needs. Chapters 10-14 covers "Bare-Metal Recovery". The author takes you through the process of a bare-metal recovery with Solaris, Linux, Windows, HP-UX, AIX, and Mac OS X. By chapters 15-22 the author has moved on to database backups and takes you through the various solutions for Oracle, Sybase, IBM DB2, SQL Server, Exchange, PostegreSQL, and MySQL. Finally the author wraps up the book with VMware server backup solutions and discussing data protection. CONCLUSION -- I found this book to be a very interesting read. I especially enjoyed the open-source, bare-metal recovery, and database sections. The author does an excellent job of taking the reader through all of the steps including example syntax needed to perform a backup and restore with the various tools discussed. Another high point is that the author includes current tools and techniques. This book holds lots of real world wisdom and I would recommend it to any system administrator, developer, or user who is interested in protecting their data.

Backup and Recovery If you ever are faced with a technical problem in your IT career, turn to O'Reilly publications and pick a book on the topic. The cover of this book fully describes its content: Inexpensive Backup Solutions for Open Systems. I was recently faced with the task of backing up MySQL databases, along with setting up reliable backup tools on client's Linux server and Windows workstations. The book helped me find all the answers; it's filled with good and practical information and is supplemented with a "healthy doze" of real life examples and anecdotes. A good number of backup tools are discussed along with configuration examples and automation procedures. Oracle, HP-UX, Windows, Linux... All you need is here.

The book is pretty well rounded and has overviews of different backup and recovery practices in addition to diving into the nuts and bolts of specific methods. Overall it is excellently written.

This version updates the 7 year old predecessor. The previous book was very good and widely respected in the UNIX and Linux community. Now Preston has expanded the coverage to include windows and MacIntosh OS-X - of interest to many enterprises with heterogenious environments. For me the updated Linux/Unix coverage was very welcome. The well organized and accessible content had immediate application myself and a client. Beyond accessibility there is also enough depth to out of trouble and with lots of references points you to sources for details beyond the context of the book. A great book on backup made even better.