Chapter 14. Developing Database Backup and Recovery Solutions
A power failure may hit your database system while it is busy processing. A user may accidentally drop a very important table that you really need. What can you do to ensure that the data in the database remains consistent even when processing has been interrupted by a power failure? How can you recover a table that has been accidentally dropped? DB2’s backup and recovery methods are designed to help you in these situations.
In this chapter you will learn about:
The concept of transaction logging and the various logging strategies
How to perform a database backup
How to perform a database restore
How to perform a roll forward operation
How log shipping works
How split mirroring works and how ...
Get Understanding DB2®: Learning Visually with Examples, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
