Skip to main content
SpringerLink
Log in
Apress
Book cover

Beginning Backup and Restore for SQL Server

Data Loss Management and Prevention Techniques

  • Book
  • © 2018

Overview

Authors:
  1. Bradley Beard

    1. Palm Bay, USA

    View author publications

    You can also search for this author in PubMed   Google Scholar

  • 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

  • 9906 Accesses

This is a preview of subscription content, log in via an institution to check access.

Access this book

Log in via an institution
eBook USD 39.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access

Licence this eBook for your library

Institutional subscriptions

Table of contents (11 chapters)

  1. Front Matter

    Pages i-xxiii
    Download chapter PDF

  2. Backups

    1. Front Matter

      Pages 1-1
      Download chapter PDF

    2. Full Backups

      • Bradley Beard
      Pages 3-21

    3. Differential Backups

      • Bradley Beard
      Pages 23-37

    4. Transaction Log Backups

      • Bradley Beard
      Pages 39-57

    5. Backup Solution Examples

      • Bradley Beard
      Pages 59-90

  3. Restores

    1. Front Matter

      Pages 91-91
      Download chapter PDF

    2. Full Restores

      • Bradley Beard
      Pages 93-126

    3. Differential Restores

      • Bradley Beard
      Pages 127-135

    4. Transaction Log Restores

      • Bradley Beard
      Pages 137-162

    5. Restore Solution Examples

      • Bradley Beard
      Pages 163-194

  4. Complete Solutions

    1. Front Matter

      Pages 195-195
      Download chapter PDF

    2. Full Backup and Restore Solutions

      • Bradley Beard
      Pages 197-256

    3. Differential Backup and Restore Solutions

      • Bradley Beard
      Pages 257-286

    4. Transaction Log Backup and Restore Solutions

      • Bradley Beard
      Pages 287-309

  5. Back Matter

    Pages 311-316
    Download chapter PDF
Back to top

Keywords

About this book

Be guided through the techniques to back up and restore databases and files in SQL Server. Multiple techniques are presented for ensuring the integrity and consistency of database backups, as well as the reliability and manageability of restoring from backups. 



In today’s data-driven world, the most important asset that a company has is its data. Data recovery strategies can be wide ranging; from the practically non-existent backup without verification to a very complex, distributed, and redundant system. An important objective for any database administrator is data loss prevention, and in a catastrophic data loss event, pre-defined data recovery techniques must be employed in order to get the databases back up and running efficiently and quickly.


Using a tutorial method of teaching, Beginning Backup and Restore for SQL Server explores the many facets behind the principles of backing up and restoring data from your database, and then shows practical application methods for getting the work done quickly and correctly. This book is an essential guide toward discovering the correct path to protecting the data for your organization. 



What You'll Learn
  • Be instructed on backup and restore techniques and principles
  • Understand the importance of a fully implemented backup plan in SQL Server Agent
  • Integrate backup and restore techniques into an existing environment
  • Consider space and time requirements for backup and restore operations
  • Master the principles for common deployment types

Who This Book Is For



Administrators who need to learn or refresh their knowledge of how to back up and restore SQL Server databases in various scenarios

Authors and Affiliations

  • Palm Bay, USA

    Bradley Beard

About the author

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.

Bibliographic Information

  • Book Title: Beginning Backup and Restore for SQL Server

  • Book Subtitle: Data Loss Management and Prevention Techniques

  • Authors: Bradley Beard

  • DOI: https://doi.org/10.1007/978-1-4842-3456-3

  • Publisher: Apress Berkeley, CA

  • eBook Packages: Professional and Applied Computing, Professional and Applied Computing (R0), Apress Access Books

  • Copyright Information: Bradley Beard 2018

  • Softcover ISBN: 978-1-4842-3455-6Published: 20 June 2018

  • eBook ISBN: 978-1-4842-3456-3Published: 19 June 2018

  • Edition Number: 1

  • Number of Pages: XXIII, 316

  • Number of Illustrations: 202 b/w illustrations

  • Topics: Database Management

Publish with us

Policies and ethics

Back to top

Search

Navigation