Beginning Backup and Restore for SQL Server

Beginning Backup and Restore for SQL Server is the essential guide to discovering the power of data protection and loss mitigation in a SQL Server environment. A company that does not protect its data will not be a company for very long. This book will guide all levels of database administrator through the steps of creating an automated database backup and restore scenario.
Too many database administrators rely on a generic maintenance plan to backup data. Catastrophic events can occur, and when they do, the seasoned DBA needs to have more than a generic backup available. This book will prepare any level DBA for these eventualities, bringing into focus such topics as backup rotation and retention periods, differing backup strategies, point-in-time restoration of data, and file/page restores.
Recovering from a catastrophic failure used to be next to impossible. With the enhanced techniques and methods you will learn in this book, those failures can be reduced, if not eliminated. SQL Server provides a wealth of tools for backing up and restoring data; this book will help you to wield those tools successfully.

Provides a singular focus on backup and restore principles Appeals to all levels of database administrators Provides version-agnostic information and applies to nearly all supported product versions

Autorentext
Bradley Beard is a professional software developer in Palm Bay, Florida. He started off designing websites using PHP and MySQL in the late 90s, and gradually moved to ColdFusion and SQL Server. He earned his MCSA: SQL Server 2012 certification in July 2013, and his MCSE: Business Intelligence certification in February 2016. He was the Technical Reviewer for Mike McQuillan's book, Introducing SQL Server, as well as the author of his own book, Practical Maintenance Plans in SQL Server, both available from Apress.

Inhalt
Introduction.- Part I: Backups.- 1. Full Backups.- 2. Differential Backups.- 3. Transaction Log Backups.- 4. Backup Solution Examples.-.-Part II: Restores.- 5. Full Restores.- 6. Differential Restores.- 7. Transaction Log Restores.- 8. Restore Solution Examples.-.-Part III: Complete Solutions.- 9. Full Backup and Restore Solutions.- 10. Differential Backup and Restore Solutions.- 11. Transaction Log Backup and Restore Solutions.