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

by: Bradley Beard (Author)

Publisher: Apress
Edition: 1st ed.

Publication Date: June 20, 2018

Language: English

Print Length: 339 pages

ISBN-10: 1484234553

ISBN-13: 9781484234556

Book Description

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 LeaBe instructed on backup and restore techniques and principlesUnderstand the importance of a fully implemented backup plan in SQL Server AgentIntegrate backup and restore techniques into an existing environmentConsider space and time requirements for backup and restore operationsMaster the principles for common deployment typesWho This Book Is ForAdministrators who need to lea or refresh their knowledge of how to back up and restore SQL Server databases in various scenarios
About the Author
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 LeaBe instructed on backup and restore techniques and principlesUnderstand the importance of a fully implemented backup plan in SQL Server AgentIntegrate backup and restore techniques into an existing environmentConsider space and time requirements for backup and restore operationsMaster the principles for common deployment typesWho This Book Is ForAdministrators who need to lea or refresh their knowledge of how to back up and restore SQL Server databases in various scenarios Read more