Beginning Backup and Restore for SQL Server

Data Loss Management and Prevention Techniques

  • Bradley Beard

Table of contents

  1. Front Matter
    Pages i-xxiii
  2. Backups

    1. Front Matter
      Pages 1-1
    2. Bradley Beard
      Pages 3-21
    3. Bradley Beard
      Pages 23-37
    4. Bradley Beard
      Pages 39-57
    5. Bradley Beard
      Pages 59-90
  3. Restores

    1. Front Matter
      Pages 91-91
    2. Bradley Beard
      Pages 93-126
    3. Bradley Beard
      Pages 127-135
    4. Bradley Beard
      Pages 137-162
    5. Bradley Beard
      Pages 163-194
  4. Complete Solutions

    1. Front Matter
      Pages 195-195
    2. Bradley Beard
      Pages 197-256
    3. Bradley Beard
      Pages 257-286
    4. Bradley Beard
      Pages 287-309
  5. Back Matter
    Pages 311-316

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


Disaster Recovery Data Protection SQL Server Agent Incremental backups Transaction log backups Differential Backup and Restore Transaction log recovery Data Archives Data Loss Prevention

Authors and affiliations

  • Bradley Beard
    • 1
  1. 1.Palm BayUSA

Bibliographic information

Industry Sectors
Materials & Steel
Chemical Manufacturing
Finance, Business & Banking
IT & Software
Consumer Packaged Goods
Energy, Utilities & Environment