Don’t miss your chance to get Apress Access at $/€ 99 through Oct 29, 2019! Subscribe now >>

Beginning Backup and Restore for SQL Server

Data Loss Management and Prevention Techniques

Authors: Beard, Bradley

Free Preview
  • 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
see more benefits

Buy this book

eBook £21.99
price for United Kingdom (gross)
  • ISBN 978-1-4842-3456-3
  • Digitally watermarked, DRM-free
  • Included format: EPUB, PDF
  • ebooks can be used on all reading devices
  • Immediate eBook download after purchase
Softcover £27.99
price for United Kingdom (gross)
  • ISBN 978-1-4842-3455-6
  • Free shipping for individuals worldwide
  • Usually dispatched within 3 to 5 business days.
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

About the authors

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.

Table of contents (11 chapters)

Table of contents (11 chapters)
  • Full Backups

    Pages 3-21

    Beard, Bradley

  • Differential Backups

    Pages 23-37

    Beard, Bradley

  • Transaction Log Backups

    Pages 39-57

    Beard, Bradley

  • Backup Solution Examples

    Pages 59-90

    Beard, Bradley

  • Full Restores

    Pages 93-126

    Beard, Bradley

Buy this book

eBook £21.99
price for United Kingdom (gross)
  • ISBN 978-1-4842-3456-3
  • Digitally watermarked, DRM-free
  • Included format: EPUB, PDF
  • ebooks can be used on all reading devices
  • Immediate eBook download after purchase
Softcover £27.99
price for United Kingdom (gross)
  • ISBN 978-1-4842-3455-6
  • Free shipping for individuals worldwide
  • Usually dispatched within 3 to 5 business days.

Services for this book

Loading...

Bibliographic Information

Bibliographic Information
Book Title
Beginning Backup and Restore for SQL Server
Book Subtitle
Data Loss Management and Prevention Techniques
Authors
Copyright
2018
Publisher
Apress
Copyright Holder
Bradley Beard
eBook ISBN
978-1-4842-3456-3
DOI
10.1007/978-1-4842-3456-3
Softcover ISBN
978-1-4842-3455-6
Edition Number
1
Number of Pages
XXIII, 316
Number of Illustrations
202 b/w illustrations
Topics