Chapter 10. Managing Data Recovery

IN THIS CHAPTER, YOU WILL LEARN TO DO THE FOLLOWING:

  • UNDERSTAND RECOVERY CONCEPTS (Pages 334 – 343)

    • Understand Transaction Architecture (Page 334)

    • Design Backup Strategies (Page 337)

  • PERFORM BACKUP OPERATIONS (Pages 344 – 355)

    • Perform Full Database Backups (Page 344)

    • Perform Differential Backups (Page 349)

    • Perform Transaction Log Backups (Page 350)

    • Perform Partial Database Backups (Page 354)

  • PERFORM RESTORE OPERATIONS (Pages 355 – 368)

    • Perform a Full Database Restore (Page 356)

    • Use Point-in-Time Recovery (Page 365)

One of the most critical parts of any database administrator's job description is handling data recovery. There are a variety of things that can go wrong, ranging from device failure to a system overheat. ...

Get SQL Server® 2008 Administration: Instant Reference 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