Advertisement

Restore and Recovery Strategies

  • Ken Simmons
  • Sylvester Carstarphen

Abstract

The ability to restore databases in SQL Server 2012 is essential to recovering a system when catastrophes arise. In order to restore your databases, you need a backup strategy that fulfills the requirements set forth by your business requirements. If your backup strategy is inadequate, then you will not be able to recover to the predetermined interval required to fulfill the requirements of your application. Ultimately, your application will lose data, and the users and your management will be very unhappy. In the last chapter, we covered the details of creating effective and efficient backup strategies. This chapter will focus on the skills needed to restore a database when the time arises.

Keywords

Recovery Strategy Execution Plan Recovery Model Recovery Option Master Database 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Ken Simmons and Sylvester Carstarphen 2012

Authors and Affiliations

  • Ken Simmons
  • Sylvester Carstarphen

There are no affiliations available

Personalised recommendations