Beginning Backup and Restore for SQL Server (eBook)
XXIII, 316 Seiten
Apress (Verlag)
978-1-4842-3456-3 (ISBN)
- 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
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.
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 LearnBe 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 learn or refresh their knowledge of how to back up and restore SQL Server databases in various scenarios
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.
IntroductionPart I: Backups1. Full Backups2. Differential Backups3. Transaction Log Backups4. Backup Solution ExamplesPart II: Restores5. Full Restores6. Differential Restores7. Transaction Log Restores8. Restore Solution ExamplesPart III: Complete Solutions9. Full Backup and Restore Solutions10. Differential Backup and Restore Solutions11. Transaction Log Backup and Restore Solutions
Erscheint lt. Verlag | 19.6.2018 |
---|---|
Zusatzinfo | XXIII, 316 p. 202 illus. |
Verlagsort | Berkeley |
Sprache | englisch |
Themenwelt | Informatik ► Datenbanken ► SQL Server |
Schlagworte | Data archives • Data Loss Prevention • data protection • Differential Backup and Restore • Disaster Recovery • Incremental backups • SQL Server Agent • Transaction log backups • Transaction log recovery |
ISBN-10 | 1-4842-3456-1 / 1484234561 |
ISBN-13 | 978-1-4842-3456-3 / 9781484234563 |
Haben Sie eine Frage zum Produkt? |
![PDF](/img/icon_pdf_big.jpg)
Größe: 11,2 MB
DRM: Digitales Wasserzeichen
Dieses eBook enthält ein digitales Wasserzeichen und ist damit für Sie personalisiert. Bei einer missbräuchlichen Weitergabe des eBooks an Dritte ist eine Rückverfolgung an die Quelle möglich.
Dateiformat: PDF (Portable Document Format)
Mit einem festen Seitenlayout eignet sich die PDF besonders für Fachbücher mit Spalten, Tabellen und Abbildungen. Eine PDF kann auf fast allen Geräten angezeigt werden, ist aber für kleine Displays (Smartphone, eReader) nur eingeschränkt geeignet.
Systemvoraussetzungen:
PC/Mac: Mit einem PC oder Mac können Sie dieses eBook lesen. Sie benötigen dafür einen PDF-Viewer - z.B. den Adobe Reader oder Adobe Digital Editions.
eReader: Dieses eBook kann mit (fast) allen eBook-Readern gelesen werden. Mit dem amazon-Kindle ist es aber nicht kompatibel.
Smartphone/Tablet: Egal ob Apple oder Android, dieses eBook können Sie lesen. Sie benötigen dafür einen PDF-Viewer - z.B. die kostenlose Adobe Digital Editions-App.
Buying eBooks from abroad
For tax law reasons we can sell eBooks just within Germany and Switzerland. Regrettably we cannot fulfill eBook-orders from other countries.
aus dem Bereich