Beginning Backup and Restore for SQL Server
Data Loss Management and Prevention Techniques
| Price | $26.76 - $33.29
|
| Rating |  |
| Author | Bradley Beard |
| Publisher | Apress |
| Published | 2018 |
| Pages | 316 |
| Language | English |
| Format | Paper book / ebook (PDF) |
| ISBN-10 | 1484234553 |
| ISBN-13 | 9781484234556 |
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.
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 (2 books)
Similar Books
Building Custom Tasks for SQL Server Integration Services, 2nd Edition
by Andy Leonard
Build custom SQL Server Integration Services (SSIS) tasks using Visual Studio Community Edition and C#. Bring all the power of Microsoft .NET to bear on your data integration and ETL processes, and for no added cost over what you've already spent on licensing SQL Server. New in this edition is a demonstration deploying a custom SSIS ...
Price: $34.99 | Publisher: Apress | Release: 2021
Expert SQL Server Transactions and Locking 
by Dmitri Korotkevitch
Master SQL Server's Concurrency Model so you can implement high-throughput systems that deliver transactional consistency to your application customers. This book explains how to troubleshoot and address blocking problems and deadlocks, and write code and design database schemas to minimize concurrency issues in the systems you devel...
Price: $24.23 | Publisher: Apress | Release: 2018
Microsoft SQL Server 2008 High Availability
by Hemantgiri S. Goswami
Install various SQL Server High Availability options in a step-by-step manner. A guide to SQL Server High Availability for DBA aspirants, proficient developers and system administrators. Learn the pre and post installation concepts and common issues you come across while working on SQL Server High Availability. Tips to enhance performance...
Price: $29.99 | Publisher: Packt Publishing | Release: 2011
Microsoft SQL Server 2008 Management and Administration
by Ross Mistry, Hilary Cotter
If you need to deploy, manage, or secure Microsoft SQL Server 2008, this is the complete, fast-paced, task-based reference you've been searching for. Authored by a world-class expert on SQL Server in the enterprise, this book goes far beyond the basics, taking on the complex tasks that DBAs need to make the most of Microsoft's f...
Price: $9.87 | Publisher: SAMS Publishing | Release: 2008
by Shawn McGehee
In this book, you'll discover how to perform each of these backup and restore operations using SQL Server Management Studio (SSMS), basic T-SQL scripts and Redgate's SQL Backup tool. Capturing backups using SSMS or simple scripts is perfectly fine for one-off backup operations, but any backups that form part of the recovery stra...
Free ebook | Publisher: Self-publishing | Release: 2012
SQL Server Execution Plans, 3rd Edition
by Grant Fritchey
Every Database Administrator, developer, report writer, and anyone else who writes T-SQL to access SQL Server data, must understand how to read and interpret execution plans. My book leads you right from the basics of capturing plans, through how to interrupt them in their various forms, graphical or XML, and then how to use the informati...
Free ebook | Publisher: Self-publishing | Release: 2018
A Developer's Guide to Data Modeling for SQL Server
by Eric Johnson, Joshua Jones
Effective data modeling is essential to ensuring that your databases will perform well, scale well, and evolve to meet changing requirements. However, if you're modeling databases to run on Microsoft SQL Server 2008 or 2005, theoretical or platform-agnostic data modeling knowledge isn't enough: models that don't reflect SQL...
Price: $6.15 | Publisher: Addison-Wesley | Release: 2008
Programming Microsoft SQL Server 2012
by Leonard Lobel, Andrew Brust
Take your database programming skills to a new level - and build customized applications using the developer tools introduced with SQL Server 2012. This hands-on reference shows you how to design, test, and deploy SQL Server databases through tutorials, practical examples, and code samples. If you're an experienced SQL Server develop...
Price: $21.95 | Publisher: Microsoft Press | Release: 2012