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 ...

Get MCITP Administrator: Microsoft® SQL Server™ 2005 Database Server Infrastructure Design Study Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial