O'Reilly logo

MCITP Administrator: Microsoft® SQL Server™ 2005 Database Server Infrastructure Design Study Guide by David W. Tschanz, J. Steven Jones

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 11

Designing a Data Recovery Solution for a Database

MICROSOFT EXAM OBJECTIVES COVERED IN THIS CHAPTER:

  • Specify data recovery technologies based on business requirements.
    • Analyze how much data the organization can afford to lose.
    • Analyze alternative techniques to save redundant copies of critical business data.
    • Analyze how long the database system or database can be unavailable.
  • Design backup strategies.
    • Specify the number and location of devices to be used for backup.
    • Specify what data to back up.
    • Specify the frequency of backup.
    • Choose a backup technique.
    • Specify the type of backup.
    • Choose a recovery model.
  • Create a disaster recovery plan.
    • Document the sequence of possible events.
    • Create a disaster decision tree that includes ...

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