![]() ![]() ![]() Backing Up with the dump Utility Section 3.5. Backing Up and Restoring with ntbackup Section 3.3. Basic Backup and Recovery Utilities Section 3.1. Good Luck Part 2: Open-Source Backup Utilities Chapter 3. Following Proper Development Procedures Section 2.10. Deciding Why You Are Backing Up Section 2.3. Wax On, Wax Off: Finding a Balance Chapter 2. Why Should I Read This Book? Section 1.3. Champagne Backup on a Beer Budget Section 1.2. Table of Contents Copyright Preface Part 1: Introduction Chapter 1. You'll find this book interesting to read, full of detail when you need it and pointed when necessary. He calls it "champagne backup on a beer budget". Nonetheless, I would recommend this book as your reference for doing database backups on any of these platforms. Databases are not simple beasts, and the backup considerations are not trivial. Learn how Oracle reconstructs your data using a hotbackup, by reading his careful discussion on the topic. For instance during an Oracle hotbackup, did you know that changes to datafiles are *NOT* frozen. So I read the chapters on Oracle and MySQL very carefully. I have worked on Unix for years and years, but my sweet spot is working with databases. Preston doesn't let anything through the cracks. And lastly, don't forget testing and verifying your backups. 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. He starts the book with the basics, what backing up is all about, why you do it, and what to consider. Each of the different databases alone do things differently, and have a lot of different concepts, and vernacular to describe it. What I was struck by most of all, after reading it, is his clear breadth of knowledge in the subject of backups. ![]() Preston though, succeeds, and succeeds with flying colors. In addition he also covers OS backups on Solaris, Linux, AIX, HP-UX, and Mac OS X. With individual chapters on every database from DB2, Oracle and Sybase to MySQL, Postgres and SQL Server. When I picked up this text, I kind of expected it to be a bit sparse in some areas. ![]()
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |