Sign-In
Cart
Database Backup and Recovery: Understanding Backup Methods, Recovery Planning, Replication, Data Protection, and Disaster Recovery
Paperback
DatabasesSystem Administration
Publisher: Independently Published
Published: Sep 17 2026
Pages: 180
Weight: 0.50
Height: 0.45 Width: 6.00 Depth: 9.00
Language: English
What happens when your database backup succeeds-but the business still cannot recover?
A successful backup job is not the same as a recoverable database. The real challenge is knowing what to protect, how much data the organization can afford to lose, how quickly service must return, and whether the recovery process has actually been tested.
Database Backup and Recovery presents a practical, vendor-neutral approach to building database resilience from the ground up. Rather than treating backup as a single task, this book shows how backup, restoration, logging, replication, high availability, disaster recovery, security, monitoring, and recovery testing fit together as one operational capability.
Inside, you'll learn how to:
- Translate business requirements into realistic RPO and RTO objectives
- Choose between full, differential, incremental, snapshot, logical, and physical backup approaches
- Design retention, storage, off-site, immutable, and isolated copies across failure domains
- Understand transaction logs, WAL, binary logs, redo, and point-in-time recovery
- Plan and execute database restoration and recovery in a controlled sequence
- Understand how replication and high availability complement-but do not replace-historical recovery
- Build practical recovery runbooks and map critical dependencies
- Prepare for site failures, regional outages, ransomware, corruption, accidental deletion, and other failure scenarios
- Secure backup repositories, credentials, encryption keys, and recovery assets
- Test recovery procedures, measure actual recovery time, validate recovery points, and monitor readiness
The book includes platform-specific examples and concepts for PostgreSQL, MySQL, Microsoft SQL Server, and Oracle Database, while keeping the underlying recovery principles vendor-neutral.
You will also work through controlled exercises involving recovery objectives, backup schedules, failure scenarios, restore procedures, runbooks, failover, and recovery testing. The goal is not simply to create more copies of data-it is to build evidence that your organization can recover the right data, to the right point, on the right platform, within the required time.
Whether you're developing your first database protection strategy or strengthening an existing environment, this book provides a structured framework for turning backup operations into measurable recovery capability.
Also from
Haagenrud, Thom
Home Assistant for Beginners: Build a private smart home without relying on the cloud
Haagenrud, Thom
Paperback
MATLAB for Engineering Students: Solve Problems, Plot Data, and Build Simple Models
Haagenrud, Thom
Paperback
PowerShell for Beginners: Automate Windows Tasks, Files, Reports, and Admin Work
Haagenrud, Thom
Paperback
Python APIs for Beginners: Connect Apps, Automate Workflows, and Use Web Data with Simple Code
Haagenrud, Thom
Paperback
Computer Vision for Robotics: Enable robots to see, detect, and respond using OpenCV
Haagenrud, Thom
Paperback
Python and MAVSDK: Connecting High-Level Code to Flight Controllers for Precise Control
Haagenrud, Thom
Paperback
Programming for Career Changers: Learn Coding Skills for Real Jobs, Portfolios, and Interviews
Haagenrud, Thom
Paperback
Python for Raspberry Pi Beginners: Build Useful Automation, Sensor, and Home Projects
Haagenrud, Thom
Paperback
PX4 and MAVLink: Integrating Open-Source Flight Control with UAV Communication
Haagenrud, Thom
Paperback
SQL for Beginners: Query, Filter, Join, and Analyze Data for Real-World Work
Haagenrud, Thom
Paperback
APIs and Webhooks for Beginners: Connect Apps, Automate Tasks, and Build Useful Integrations
Haagenrud, Thom
Paperback
Tasmota Firmware Flashing: Unlocking the full potential of Tuya and Sonoff smart plugs
Haagenrud, Thom
Paperback
REST API Security Protecting Data in Transit: Secure REST APIs with authentication and encryption
Haagenrud, Thom
Paperback
JavaScript for Practical Web Projects: Build Interactive Pages Without Getting Lost
Haagenrud, Thom
Paperback
UAV Programming with Python: A Developer's Guide to MAVLink Communication, PX4 Integration, and Onboard Scripting
Haagenrud, Thom
Paperback
Lua for Game Scripting Beginners: Create Simple Game Logic, Mods, and Automation Scripts
Haagenrud, Thom
Paperback
Java for Beginners Through Projects: Learn Coding by Building Practical Applications
Haagenrud, Thom
Paperback
Coding Projects for Absolute Beginners: 25 Simple Apps to Build Confidence in Any Language
Haagenrud, Thom
Paperback
Java for Android Beginners: Build Simple Mobile Apps with Real-World Features
Haagenrud, Thom
Paperback
Coding for Non-Programmers: Master Python Fundamentals in 14 Days Without Getting Overwhelmed by Technical Jargon
Haagenrud, Thom
Paperback
No-Fluff Coding Logic for Beginners: Learn Variables, Loops, Functions, and Problem Solving
Haagenrud, Thom
Paperback
Machine Learning Made Easy: A Plain-English Introduction to How Intelligent Algorithms Learn and Make Predictions
Haagenrud, Thom
Paperback
Artificial Intelligence for Absolute Beginners: Understand How AI Works and Start Building Your Own Basic Smart Applications
Haagenrud, Thom
Paperback
Git and GitHub for Beginner Programmers: Track Code, Fix Mistakes, and Publish Projects
Haagenrud, Thom
Paperback
OpenHAB Implementation: Integrating diverse smart devices into a single open-source interface
Haagenrud, Thom
Paperback
Data Structures for Beginners: Learn Arrays, Lists, Stacks, Queues, Trees, and Graphs Simply
Haagenrud, Thom
Paperback
Python Dashboards for Beginners: Build Simple Data Apps with Streamlit and Plotly
Haagenrud, Thom
Paperback
Python for Small Business: Automate Invoices, Customer Lists, Reports, and Admin Work
Haagenrud, Thom
Paperback
MySQL for Beginners: Build, Query, and Manage Databases for Websites and Small Apps
Haagenrud, Thom
Paperback
PostgreSQL for Beginners: Learn Databases, Queries, Tables, and Practical Projects
Haagenrud, Thom
Paperback
JavaScript Automation for Beginners: Automate Browsers, Forms, Data Tasks, and Web Workflows
Haagenrud, Thom
Paperback
Python Automation for Beginners: Save Time with Scripts for Files, Folders, Emails, Reports, and Daily Tasks
Haagenrud, Thom
Paperback
Dart and Flutter for Beginners: Build Mobile Apps for Android and iOS from One Codebase
Haagenrud, Thom
Paperback
Rust for Curious Beginners: Learn Memory-Safe Programming Through Practical Projects
Haagenrud, Thom
Paperback
UAV Mission Planning: Strategies for Autonomous Mapping, Surveillance, and Inspection
Haagenrud, Thom
Paperback
ROS for Drone Development: A Practical Introduction to Building Autonomous UAVs with ROS, MAVLink, and Gazebo Simulation
Haagenrud, Thom
Paperback
Zigbee Network Optimization: Designing robust mesh networks for reliable device communication
Haagenrud, Thom
Paperback
WLED Lighting Control: Creating synchronized LED effects and ambiance with ESP8266
Haagenrud, Thom
Paperback
Introduction to Vulnerability Assessment: Understanding Security Weaknesses, Risk Evaluation, Scanning, and Remediation
Haagenrud, Thom
Paperback
Working with Relational Data: An Introduction to Tables, Relationships, Queries, Data Integrity, and Database Applications
Haagenrud, Thom
Paperback
Python Testing and Debugging for Beginners: Write Better Code and Fix Errors with Confidence
Haagenrud, Thom
Paperback
Python Web Scraping for Beginners: Collect, Clean, and Organize Online Data with Practical Projects
Haagenrud, Thom
Paperback
Linux Kernel Programming Essentials: A Practical Guide to Kernel Internals, Modules, Drivers, Memory, and System Development
Haagenrud, Thom
Paperback
Also in
System Administration
All Data Are Local: Thinking Critically in a Data-Driven Society
Loukissas, Yanni Alexander
Paperback
Learn Powershell in a Month of Lunches, Fourth Edition: Covers Windows, Linux, and macOS
Petty, James
Leonhardt, Tyler
Plunk, Travis
Paperback
Certified Kubernetes Administrator (Cka) Study Guide: In-Depth Guidance and Practice
Muschko, Benjamin
Paperback
Learning eBPF: Programming the Linux Kernel for Enhanced Observability, Networking, and Security
Rice, Liz
Paperback
The Book of Pf, 4th Edition: A No-Nonsense Guide to the OpenBSD Firewall
Hansteen, Peter N. M.
Paperback
Cilium: Up and Running: Cloud Native Networking, Security, and Observability
Laverack, James
Vibert, Nico
Nikolic, Filip
Paperback
Observability Engineering: Achieving Production Excellence
Fong-Jones, Liz
Miranda, George
Majors, Charity
Paperback
SQL Server 2025 Unveiled: The Ai-Ready Enterprise Database with Microsoft Fabric Integration
Ward, Bob
Paperback
Windows 11 Manual For Seniors: A Beginners Guide to Navigate Your Computer with Step-by-Step Instructions
Wells, Larry
Paperback
Linux Mint Cinnamon Edition: A Complete Guide for Beginners and Advanced Users
Rodgers, David A., Jr.
Paperback
Agentic Architectural Patterns for Building Multi-Agent Systems: Proven design patterns and practices for GenAI, agents, RAG, LLMOps, and enterprise-s
Arsanjani, Ali
Bustos, Juan Pablo
Paperback
Industrial Cybersecurity - Second Edition: Efficiently monitor the cybersecurity posture of your ICS environment
Ackerman, Pascal
Paperback
Salesforce Certified Platform Administrator Study Guide: Launch and Elevate Your Salesforce Career
Wheeler, Mike
Paperback
Linux for Beginners: An Introduction to the Linux Operating System and Command Line
Cannon, Jason
Paperback
E-mail: A Write It Well Guide: How to Write and Manage E-mail in the Workplace
Chan, Janis Fisher
Paperback
Evasion Engineering: Building Custom Red Team Tools for Modern Defenses
Lasalvia, Michael
Chow, Dennis
Paperback
Building AI Agents with LLMs, RAG, and Knowledge Graphs: A practical guide to autonomous and modern AI agents
Iuculano, Gabriele
Raieli, Salvatore
Paperback
Wireless Exploits And Countermeasures: Kali Linux Nethunter, Aircrack-NG, Kismet, And Wireshark
Botwright, Rob
Paperback
Microsoft Power Automate Cookbook: Automating Business Processes Easily, Intuitively, and Quickly
Najjar, Ahmad
Paperback
Docker: Up & Running: Shipping Reliable Containers in Production
Kane, Sean P.
Matthias, Karl
Paperback
The Accidental Administrator: Cisco Router Step-by-Step Configuration Guide
Crawley, Don R.
Paperback
Welcome to the Cold Aisle: A Data Center Technicians No-Nonsense Survival Guide For Day One And On
Ortiz, Jason
Paperback
Windows Internals: System Architecture, Processes, Threads, Memory Management, and More, Part 1
Russinovich, Mark
Solomon, David
Yosifovich, Pavel
Paperback
Data and Reality: A Timeless Perspective on Perceiving and Managing Information in Our Imprecise World, 3rd Edition
Kent, William
Paperback
Kill It with Fire: Manage Aging Computer Systems (and Future Proof Modern Ones)
Bellotti, Marianne
Paperback
Linux: A Complete Guide to Learn Linux Commands, Linux Operating System and Shell Scripting Step-by-Step
Ayden, Nicholas
Paperback
Linux Kernel Programming - Second Edition: A comprehensive and practical guide to kernel internals, writing modules, and kernel synchronization
Billimoria, Kaiwan N.
Paperback
Building Secure and Reliable Systems: Best Practices for Designing, Implementing, and Maintaining Systems
Adkins, Heather
Blankinship, Paul
Beyer, Betsy
Paperback
SAP S/4hana Financial Accounting Certification Guide: Application Associate Exam
Pougkas, Stefanos
Paperback
Prometheus: Up & Running: Infrastructure and Application Performance Monitoring
Brazil, Brian
Pivotto, Julien
Paperback
Linux: The ultimate guide to Linux for beginners, Linux hacking, Linux command line, Linux operating system, and more!
Newport, Craig
Paperback
Graph-Powered Analytics and Machine Learning with Tigergraph: Driving Business Outcomes with Connected Data
D, Victor Lee Ph.
Nguyen, Phuc Kien
Thomas, Alexander
Paperback
Microsoft 365 and SharePoint Online Cookbook - Second Edition: A complete guide to Microsoft Office 365 apps including SharePoint, Power Platform, Cop
Chamberlain, Nate
Mahajan, Gaurav
Ghatak, Sudeep
Paperback
Mastering Embedded Linux Development - Fourth Edition: Craft fast and reliable embedded solutions with Linux 6.6 and The Yocto Project 5.0 (Scarthgap)
Vasquez, Frank
Simmonds, Chris
Paperback
Acing the Certified Kubernetes Administrator Exam, Second Edition
Brito, Rafael
Crowell, Chad
Paperback
Building Multi-Tenant Saas Architectures: Principles, Practices, and Patterns Using AWS
Golding, Tod
Paperback
The Practice of Network Security Monitoring: Understanding Incident Detection and Response
Bejtlich, Richard
Paperback
Building Green Software: A Sustainable Approach to Software Development and Operations
Currie, Anne
Hsu, Sarah
Bergman, Sara
Paperback
Powershell Cookbook: Your Complete Guide to Scripting the Ubiquitous Object-Based Shell
Holmes, Lee
Paperback
Practical Linux System Administration: A Guide to Installation, Configuration, and Management
Hess, Kenneth
Paperback
Red Hat Certified Engineer (Rhce) Ansible Automation Study Guide: In-Depth Guidance and Practice
Bueno, Alex Soto
Block, Andrew
Paperback
Cloud Native Data Security with Oauth: A Scalable Zero Trust Architecture
Trojanowski, Michal
Archer, Gary
Kahrer, Judith
Paperback
CCNA Automation Ccnaauto 200-901 Official Cert Guide
Malegaonkar, Ashutosh
Jackson, Chris
Iliesiu, Adrian
Paperback
Mastering NLP From Foundations to Agents - Second Edition: Building AI Agents through Agentic Automation and RAG Workflows with Python
Gazit, Lior
Ghaffari, Meysam
Paperback
Debian 13.3 "Trixie" Desktop Handbook: A Practical Guide to Installing, Securing, and Mastering the Debian Linux Desktop - From Install to Advanced Ad
Rodgers, David A., Jr.
Paperback
Data Modeling for MongoDB: Building Well-Designed and Supportable MongoDB Databases
Hoberman, Steve
Paperback
PowerShell Automation and Scripting for Cybersecurity: Hacking and defense for red and blue teamers
Wiesner, Miriam C.
Paperback
Ubuntu 26.04 LTS: A Comprehensive Guide for Beginners and Advanced Users
Rodgers, David A., Jr.
Paperback
The Ultimate Linux Shell Scripting Guide: Automate, Optimize, and Empower tasks with Linux Shell Scripting
Tevault, Donald a.
Paperback
Mastering Windows Security and Hardening - Second Edition: Secure and protect your Windows environment from cyber threats using zero-trust security pr
Tumbarello, Matt
Dunkerley, Mark
Paperback
Using Digital Information Services in the Library Workplace: An Introduction for Support Staff
Shaw, Marie Keen
Paperback
Python for Devops: Learn Ruthlessly Effective Automation
Behrman, Kennedy
Deza, Alfredo
Gift, Noah
Paperback
SAP Master Data Governance: The Comprehensive Guide
Kalwachwala, Homiar
Dogra, Bikram
Isacc, Antony
Hardcover
Practical Threat Detection Engineering: A hands-on guide to planning, developing, and validating detection capabilities
Katz, Gary J.
Deyalsingh, Jason
Roddie, Megan
Paperback
Red Hat Enterprise Linux 10 Essentials: Learn to Install, Administer and Deploy RHEL 10 Systems
Smyth, Neil
Paperback
Cybersecurity Ops with Bash: Attack, Defend, and Analyze from the Command Line
Troncone, Paul
D. Carl Albing Ph.
Paperback
A Friendly Guide to Data Science: Everything You Should Know about the Hottest Field in Tech
Vincent, Kelly P.
Paperback
Version Control with Git: Powerful Tools and Techniques for Collaborative Software Development
Ponuthorai, Prem Kumar
Loeliger, Jon
Paperback
Ethernet: The Definitive Guide: Designing and Managing Local Area Networks
Zimmerman, Joann
Spurgeon, Charles E.
Paperback
Kubernetes Best Practices: Blueprints for Building Successful Applications on Kubernetes
Villalba, Eddie
Strebel, Dave
Burns, Brendan
Paperback
pfSense Essentials: The Complete Reference to the pfSense Internet Gateway and Firewall
Reed, Jeremy C.
Paperback
The Kubernetes Bible - Second Edition: The definitive guide to deploying and managing Kubernetes across cloud and on-prem environments
Madapparambath, Gineesh
McKendrick, Russ
Paperback
Attack Surface Management: Strategies and Techniques for Safeguarding Your Digital Assets
Eddings, Ron
Kaufmann, Mj
Paperback
Cracking the Kubernetes Interview: Discover expert tips and best practices to ace your Kubernetes technical interviews
Vedmich, Viktor
Dovnar, Alexander
Paperback
Cisa Certified Information Systems Auditor All-In-One Exam Guide, Fourth Edition
Gregory, Peter H.
Paperback
From Cloud Native to AI Native: Catching the Next Wave of Innovation
Reznik, Pini
Müller, Michael
Paperback
Free Opensource Office Suite Software Apps For Windows 11 OS Hardcover Ver
Sakura, Cyber Jannah
Hardcover
The FPGA Programming Handbook - Second Edition: An essential guide to FPGA design for transforming ideas into hardware using SystemVerilog and VHDL
Bruno, Frank
Eschemann, Guy
Paperback
Learn Linux Quickly: A Comprehensive Guide for Getting Up to Speed on the Linux Command Line (Ubuntu)
Bartley, Paul H.
Quickly, Code
Paperback
Kubernetes Security and Observability: A Holistic Approach to Securing Containers and Cloud Native Applications
Gupta, Amit
Creane, Brendan
Paperback
DevOps and Site Reliability Engineering (SRE) Handbook: Non-Programmer's Guide
Fleming, Stephen
Paperback
Data Quality Fundamentals: A Practitioner's Guide to Building Trustworthy Data Pipelines
Gavish, Lior
Vorwerck, Molly
Moses, Barr
Paperback
Architecting for Scale: How to Maintain High Availability and Manage Risk in the Cloud
Atchison, Lee
Paperback
Desktop Support Crash Course: Technical Problem Solving And Network Troubleshooting
Botwright, Rob
Paperback
Business Continuity and Disaster Recovery Planning for IT Professionals
Snedaker, Susan
Rima, Chris
Paperback
IoT and OT Security Handbook: Assess risks, manage vulnerabilities, and monitor threats with Microsoft Defender for IoT
Lakshmi, Vasantha
Jain, Smita
Paperback
Business Database Technology (2nd Edition): Theories and Design Process of Relational Databases, SQL, Introduction to OLAP, Overview of NoSQL Database
Wang, Shouhong
Wang, Hai
Paperback
NMAP Network Scanning Series: Network Security, Monitoring, And Scanning Library
Botwright, Rob
Paperback
Generative AI for Software Developers: Future-proof your career with AI-powered development and hands-on skills
Arora, Kamal
Dubey, Ashutosh
Shrivastava, Saurabh
Paperback
The Expert in the Next Office: Tools for Managing Operations and Security in the Era of Cyberspace
Kabay, M. E.
Paperback
SUSE Linux Enterprise Server 16 Official Administration Guide: Master SLES 16 system administration, security, and automation for the SCA exam
Gómez, Pablo Iranzo
Cárdenas, Sergio Ocón
Colino, Miguel Pérez
Paperback
Linux Command Line: The Simple and Powerful Guide to Master Shell Scripting
A. Williams, David
Paperback
Microsoft 365 Fundamentals Guide: Over 100 tips and tricks to help you get up and running with M365 quickly
Romão, Douglas
Moraes, Gustavo
Paperback
Kubernetes: The Ultimate Guide to Learn and Master Kubernetes for Beginners (Effectively Learn Kubernetes Step-by-step)
Bennett, Melvin
Paperback
Windows 11 for Enterprise Administrators - Second Edition: Unleash the power of Windows 11 with effective techniques and strategies
Miles, Steve
Singer, Manuel
Stokes, Jeff
Paperback
Unix And Linux System Administration Handbook: Mastering Networking, Security, Cloud, Performance, And Devops
Botwright, Rob
Paperback
Hands-On MLOps on Azure: Automate, secure, and scale ML workflows with the Azure ML CLI, GitHub, and LLMOps
de, Banibrata
Paperback
Oracle Solaris 11.2 System Administration Handbook (Oracle Press)
Foxwell, Harry
Foster, Glynn
Paperback
Learn Linux Quickly: A beginner-friendly guide to getting up and running with the world's most powerful operating system
Alkabary, Ahmed
Paperback
Mastering KVM Virtualization - Second Edition: Design expert data center virtualization solutions with the power of Linux KVM
Chirammal, Humble Devassy
Mukhedkar, Prasad
Dakic, Vedran
Paperback
Learn OpenShift - Second Edition: Master container orchestration with OpenShift 4 - architecture, deployment, and operations
Varlamov, Aleksandr
Usov, Aleksey
Zuev, Denis
Paperback