Chapter 20. Data Recovery

After completing this chapter, you will be able to

  • Back up databases

  • Manage recovery models

  • Restore databases

SQL Server 2008 provides a flexible and powerful data platform. Without the needs of businesses to securely store and retrieve data, SQL Server would not exist. Without the ability of SQL Server to store and protect the data that businesses are dependent upon, businesses would not exist. As you learned in Chapter 18, one of the two fundamental tasks of a Database Administrator is to ensure instances, databases, and data is secured. The second fundamental task of a Database Administrator is to ensure that data is protected and recoverable.

The thousands of features within SQL Server that are designed for organizations ...

Get Microsoft® SQL Server® 2008 Step by Step 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.