Chapter 17Backup and Recovery


  • Understanding different types of failures and why they occur
  • Planning for disasters
  • Understanding how backup works
  • Choosing the right backup configuration for your environment
  • Recovering databases when a problem occurs


The code downloads for this chapter are found at on the Download Code tab. The code is in the Chapter 17 download and individually named according to the names throughout the chapter.

Data is a critical asset. Over the course of many years, organizations amass information about their customers, inventory, purchases, financials, and products. Over the course of many years, organizations amass information to improve the daily customer experience, as well as to leverage this information to support strategic decisions. Downtime is unacceptable, and can be costly for the organization. For example, without their databases, a stock brokerage house cannot take stock orders and an airline cannot sell tickets. Every hour the database is down can add up to millions of dollars of business opportunities lost. To keep their business activities going, organizations deploy high-availability solutions (such as failover clustering, database mirroring, replication, and log shipping) so that when a database server fails, they can continue to run their business on a standby database server. All these topics are covered in other chapters in this ...

Get Professional Microsoft SQL Server 2014 Administration now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.