Beginning Backup and Restore for SQL Server

Data Loss Management and Prevention Techniques



Bookstore > Books > Beginning Backup and Restore for SQL Server

Price$26.76 - $33.29
Rating
AuthorBradley Beard
PublisherApress
Published2018
Pages316
LanguageEnglish
FormatPaper book / ebook (PDF)
ISBN-101484234553
ISBN-139781484234556
EBook Hardcover Paperback

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.


  1. (2 books)


Similar Books


Building Custom Tasks for SQL Server Integration Services, 2nd Edition

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

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

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

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

SQL Server Backup and Restore

SQL Server Backup and Restore

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

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

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

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