O'Reilly logo

Professional Microsoft SQL Server 2014 Administration by Brian Knight, Ross LoForte, Steven Wort, Bradley Ball, Adam Jorgensen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 17Backup and Recovery

WHAT'S IN THIS CHAPTER?

  • 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

WROX.COM CODE DOWNLOADS FOR THIS CHAPTER

The wrox.com code downloads for this chapter are found at www.wrox.com/go/prosql2014admin 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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required