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

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

Full description

Bibliographic Details
Main Author: Beard, Bradley
Format: eBook
Language:English
Published: Berkeley, CA Apress 2018, 2018
Edition:1st ed. 2018
Subjects:
Online Access:
Collection: Springer eBooks 2005- - Collection details see MPG.ReNa
LEADER 02829nmm a2200265 u 4500
001 EB001841377
003 EBX01000000000000001005366
005 00000000000000.0
007 cr|||||||||||||||||||||
008 180702 ||| eng
020 |a 9781484234563 
100 1 |a Beard, Bradley 
245 0 0 |a Beginning Backup and Restore for SQL Server  |h Elektronische Ressource  |b Data Loss Management and Prevention Techniques  |c by Bradley Beard 
250 |a 1st ed. 2018 
260 |a Berkeley, CA  |b Apress  |c 2018, 2018 
300 |a XXIII, 316 p. 202 illus  |b online resource 
505 0 |a 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 
653 |a Database Management 
653 |a Database management 
041 0 7 |a eng  |2 ISO 639-2 
989 |b Springer  |a Springer eBooks 2005- 
028 5 0 |a 10.1007/978-1-4842-3456-3 
856 4 0 |u https://doi.org/10.1007/978-1-4842-3456-3?nosfx=y  |x Verlag  |3 Volltext 
082 0 |a 005.74 
520 |a 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