Cantitate/Preț
Produs

Beginning Backup and Restore for SQL Server: Data Loss Management and Prevention Techniques

Autor Bradley Beard
en Limba Engleză Paperback – 20 iun 2018
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
Citește tot Restrânge

Preț: 44395 lei

Preț vechi: 55494 lei
-20% Nou

Puncte Express: 666

Preț estimativ în valută:
8496 8825$ 7057£

Carte disponibilă

Livrare economică 13-27 ianuarie 25

Preluare comenzi: 021 569.72.76

Specificații

ISBN-13: 9781484234556
ISBN-10: 1484234553
Pagini: 284
Ilustrații: XXIII, 316 p. 202 illus.
Dimensiuni: 155 x 235 mm
Greutate: 5.15 kg
Ediția:1st ed.
Editura: Apress
Colecția Apress
Locul publicării:Berkeley, CA, United States

Cuprins

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.

Notă biografică

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.

Textul de pe ultima copertă

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 fromyour 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


Caracteristici

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