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

Bradley Beard

  • 出版商: Apress
  • 出版日期: 2018-06-20
  • 售價: $1,680
  • 貴賓價: 9.5$1,596
  • 語言: 英文
  • 頁數: 340
  • 裝訂: Paperback
  • ISBN: 1484234553
  • ISBN-13: 9781484234556
  • 相關分類: MSSQLSQL
  • 海外代購書籍(需單獨結帳)

買這商品的人也買了...

商品描述

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

商品描述(中文翻譯)

這本書將引導讀者學習在SQL Server中備份和還原數據庫和文件的技巧。書中介紹了多種技術,以確保數據庫備份的完整性和一致性,以及從備份中可靠且易於管理地還原數據的可靠性。在當今數據驅動的世界中,公司最重要的資產就是其數據。數據恢復策略可以涵蓋從幾乎沒有驗證的備份到非常複雜、分散和冗余的系統。任何數據庫管理員的重要目標都是防止數據丟失,在災難性數據丟失事件中,必須使用預定義的數據恢復技術來高效且快速地恢復數據庫的運行。本書使用教學方法,探討了從數據庫中備份和還原數據背後的許多方面原則,並展示了快速且正確完成工作的實際應用方法。本書是發現保護組織數據的正確途徑的重要指南。

本書的學習內容包括:
- 學習備份和還原技術和原則
- 了解在SQL Server Agent中完全實施備份計劃的重要性
- 將備份和還原技術整合到現有環境中
- 考慮備份和還原操作的空間和時間要求
- 掌握常見部署類型的原則

本書適合需要學習或更新在各種情境下如何備份和還原SQL Server數據庫的管理員。